/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50610
Source Host           : localhost:3306
Source Database       : jeechart

Target Server Type    : MYSQL
Target Server Version : 50610
File Encoding         : 65001

Date: 2014-09-18 17:29:56
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for act_ge_bytearray
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_bytearray`;
CREATE TABLE `act_ge_bytearray` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`REV_`  int(11) NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DEPLOYMENT_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`BYTES_`  longblob NULL ,
`GENERATED_`  tinyint(4) NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_ge_bytearray
-- ----------------------------
BEGIN;
INSERT INTO `act_ge_bytearray` VALUES ('33b4819cadf84f41a9610173f0e10cd1', '1', 'leave.png', '9285364c4fb44bdab52c0a7a7e9200c8', 0x89504E470D0A1A0A0000000D49484452000004CF0000026208020000005F2772930000379849444154789CEDDD7F8CA4F57D1FF0C518585B465C95D49C2B0726E91FACE2DAB7AA23717F95C3517D5BA9B557AA65B6FEE3BC9265FBACA40EAAAA64DD0A5FD5989EAAC6BDA43622AD4D56AD68B78A0EAF14EC5E62703636902B60380C67AF81338B01676DC05ECA1D0CF7839B3EB7634F86F9F9CCEE77E63BCFF779BDF4D5696E77E6D967BECFE779BE9FF7CDDECC440D000000429B88BD030000002448DA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A4CD3EAAD5EAD2D2D2DCDCDC9E3D7B2A95CA445965CF3D9B81D9D9D9C5C5C58D8D8DD8878531E21CA9738E148BBAAD53B7000C95B4D9CB912347B295386B476EBFFDF6BBEEBEFBC91327CE9C3D5BCE913DF76C060E1F3EBC6FDFBE6C4EB2BE24F6C1612C38479C2345A46ED52D00A3216D76B6B1B1313F3FBF77EFDE679E7DE6CCD93346F378FE85E7B3BE249B9CF5F5F5D8078A689C23CE912252B7EA16805192363BC8DA91E9E9E92FDFF6A533674F1BDDC69D5FBDF3DA6BAF5D5B5B8B7DB888C039E21C292275AB6E01183169B383F9F9F9CD76E435A3F7B8EBEEAF5F77DD3F8A7DB888C039E21C292275AB6E01183169B3D5912347F6EE7DFFD9735523CFF8DDDFFBD737DFFCFBB10F1A23E51C718E1491BA55B7008C9EB4F906D56AB552A93CFBDCDAD973AF1A79C6C9533FDBB5EB3DABABABB10F1D23E21C718E1491BA55B70044216DBEC1E2E2E2FCFCFCD973AF34C6F533FF34E7FBC8373FAA54E3E69BFFFDC2C242EC43C78838479C2345A46ED52D0051489B6F303B3B7BF88EFFFDB7EDC8FBF7FE4DADF6F4EBB527CED6BE7BBAF6C8E9DA8327CF1DBAE31B7FF1DC4BF79FA9FDDF6AEDFE6AED9E576A5F7FADF647F73CFA89FD9F8CDE1C4419DF7EE8E8F4F474EC43375CF5F7B1F4617435E7488AE74819CA5BDDA657B7001482B4F906535353C78F3F7CF6DCA9FA9898983859AB9D3A5F7BE95CEDA7676AAFD46AFFEADF7C76E24D6FDBFDFED9E7CED69E395D7BE6B5DA5AB5F6E4B9DA9FFEF5239BFF047EAA84E3E4A917272727631FBA21CABAF0EBAEBBEECBB7DDB667CF9EB43BF23C9C23899D2325296F759B58DD02501401D266B55A5D5E5E3E70E0C0ECECEC9E5F989999C9BEB2B4B454ACF665C78E1D2FBCF8DCD97327EB236B325E79BD76FAF50BDF3A77FEC29F7FF6B53FFF7B7FFF1FFCDBCFFDC1B95AEDE573B597CED67E7AB6963DC3AF3FF09DCD8EE4643947F6DCE31EB8E1A9F7E20F7EFBA13367CF657FA6DD91E7E11C49E91C294F79ABDB94EA168002D9D6429285CC2C554E4E4E663933CB96870FDF71D7DDDFA88F3BBFFAB59B6EFAECDCDC5CB6C6EFDEBD7B717131D00E0FD76657F17263647F3D75AEF6E2ABB533AFFFFC0E592BF69FBFF0C7BFFF9FBEF0CC8F2E7CF8F5D9F3B5339B9DCA7DDF7EA4E5B1A51AA97624CDBD787D8C49471E71C29D23C99C23E353DE23981C759B4CDD02502C5B5C488E1D3B96352559C8CC5265A353E936EEB9F7BE7DFB3E3A3D3DBDB2B21274E7C3DBEC2AFE5F635CE8485EAF3DFF4AEDC7276B676BB533A74F4F5D73CDC4C4C51313931FFA17FB9A1FF8E0430FB73CB65423C98EA4BD171F5E47DEFB4D4AFADE27E09EE4D955E74802E7C850CB7B0CEB59DDA651B70014CE56169283070F66D1F1AEBBBFD13767B634315973B37FFFFE6AB51AFC6984B2D955BCD418139BBF6DF5E2ABB51FBD5CFBC96BB5078FFFE0CA2BAFBCF8CD97BEE58A5F9EFBC81B3A9207BEFD50CB634B35D2EB48BAF5E2430A9C3D26B0E55BCD7F8D32EDCE9104CE916197F718D6B3BA4DA06E0128A2C116922C28CECDCD2D2C2C0C94339BC7176FB925EB63D6D7D787F47CB669B3ABD8688CECAFAF9EAFFDB47AE1DFBF9F7FAD76F703ABEFDEF5DE5FFEBB6FBF62C7DFF9E3FFFEA7AFD56A274FD75E397DE181F71C7DA0E5B1A51A897524BD7BF16104CEFA04767C91A7DBB746F07250B75D758E14FA1C1941798F613DABDBA2D72D000535C0429245CDDDBB772F2D2D6D396A367EB136DBCEDADADAD09ED4D6652BEBB9733F6B8CFA429B35252F9DADFDEC4CED472F9FBDEFD1B55DFFF037AEFFC7FFE427A76B3FAED67E52ADBD78BA96F524F7DCFF40CB634B3552EA48F2F4E2C10367CED782DAEF36FA99778E14FA1C194D798F613DABDB42D72D00C535C042323737B7FDA8D9E863B2C03986BF52DBD255ECB9FEBAEF7CEF89071F5D3D7A6CF5DE8756EF7DF8F1FBBE73E22FEFFFEE5F3FFAD4371F7AFC5B0F7DFFDE87BF7FF491C71F7DE287B7FCD7DB3E7CC387A377063A926DCADF8B870D9C7D5F0B6ADC2DE2AB9A8D7D708E14F41C1959798F613DABDBE2D62D00859677213978F0E0767E81B67D1C3E7CC7ECECEC509FDB166C76243F6D1EBFF55B9FECFACB5E4DFEF9873ED4F2C0528D343A92417BF18081B3BD11EFF8C551BE16D48D73A4A0E7C828CB7B0CEB59DD16B46E0128BA5C0BC9B163C7A6A7A70346CDFAF8C4273E79EBADB70EFB190E64B32379D1187424D0916CAD170F1538F377E7EDB6FC43B7BCABD1EBAD8823EE3932E2F21EC37A56B745AC5B0012906B21C9A2E6D6DA94DEE399679FBBFAEACA58FD3EED858EE4F5178C4147D13B92F65EFCCEAF7EED9A6BA69E3C71A263E93EFFC28BBB76EDFAF26DB7850A9C8D46BCBDF3EE38B71127DC3952B87364F4E53D86F5AC6E0B57B700A4A1FF42B2BCBC3C3B3B1B3C6AD6C7A73FFD3B870E1D1AC1F3CC69B32379DE187414BA23E9D88B4F4E4E664FEAEAAB2BED1D79BD17AF77CFA102678F096C7CABA5596FBF311ACE91629D2351CA7B0CEB59DD16AB6E014846FF8524EB3006FD68CD815EDEDCB973E7089E674E9B1DC94F8C4147713B921EBD785D4B47DEDC8B070C9C5BE8CE7B7C71A89C23053A476295F718D6B3BA2D50DD0290923E0B49D658ECD8B1634851B33EAEBDF6DAA3478F8EE6D9F6B5D991FCD8187414B42369EFC55F3E796AE7CE9D2DBFFED7E8C8DB7BF14CD6BB3FF3EC73DB0C9CDD7EBDB0E3EF1FB6EC40B7870F8973A428E748C4F21EC37A56B745A95B0012D36721595C5C9C9F9F1F6ADAFCDCCD372F2C2C8CE6D9D62D2D2D75FBB4CFCD8E64DD18748C5B47D2E31037747BDF94EC2B3B76EC68EFC81F7AF8E18EBDF89D5FFD5AFB16427D0E672CCE91713E47947737EA769CEB168072EAB390ECDFBFFFD65B6F1D6ADABCEBEE6F64BDCB689E6DE6F1C71FAF3752975F7EF9E1C3875BBEAB2349A023E97D88EB7ABF4567C78EFCD24B2FCDD38B8F7F47DE9773649CCF11E5DD8DBA1DE7BA05A0B4FA2C24333333DD1A8E50E3C91327AEBEBA329A679BA956AB6F7AD39BEA4DC925975CF2AE77BDABF9DFC2373B92BF31061D63D591F43EC4B57C9F06D1B123CFD98B8F73479E8773649CCF11E5DD8DBA1DE7BA05A0B4FA2C2443FAEC93E6F1F2C9535967339A675BD7F23F97DEF296B77CEC631FAB7F104BF6D7D75FFF9131E818B78EA4C721CEFFC1833D3AF2BEBDF8D876E4393947C6F91C51DEDDA8DB71AE5B00CAA9CF42922DDECD6F1131A491AD6759D7D2E31FDA47E9F5D79F33061D13E374047BCB7AF1FCEFB1FC972B7F75F1C517B76CE1A28B2EBAEDB63FC9B985FA2F8A176572728A5E6F451C1323394794770FD16BA0886342DA04607BFA2C245353538F1D3F3E82B4399A675B77C5155734FA8FD94D59B7B4BABA5AFBF9BF7F3F6B0C3AC6AD23E971888F1D3B9675E4CFBFF062DFB2ECF8169D751D3FA8B0E316B29F9BFDC4D8F33130E7C8389F23CABB1B753BCE750B4039F5594886FA619BF531E2FFB7B9B1B151EF45B220FDF18F7F3CFB736969A9F1DDCD8EE4992D8CDE0F6C7CB7CBBFB8E7DA48B787B76C24CF5E35EF4FCE1FDD77C7467604FBEA7D886BF93AF21EBD78CE8E7C0C7BF19C86748E843A9BB67F9FE0F53FCA7344797713BD6EF3D761C79D89B88723A85B004AABCF42323F3FDFFCE9DEC318F7DC7BDFB5D75E3B9A679B79FAE9A72727276766662A95CAC2C242CB7F3ADA5CEF7F38D0684B7D3F6CF96BE36EDD1EDEED76FB76FA6EA447FBD8713B7DB79C7F12467604FBEA7D88EB7A77E41D7BF18B2EBA287F473E86BD787EC1CF912D9453DF13AD636DC7AAFF519E23CABB9BE875DBE3D037EAB347E1F528E6587B1EB06E0128AD3E0BC9A143873EFDE9DF196ADACCD2ECBE7D1F1DC993FDB9E5E5E5C5C5C58E1FCB16645D1FA8856DB973CB43DAFF9AB38DCEB963A1DAEE71EB487A1CE2866E1D79B7CFB8FFA3FFF2858E1F54D8DE918F672F3E90619F23394F8A816A3862FD8FF81C51DEDDC4ADDB3CC5DC7C9D6F2FDD3CABC0E8F77FE4871180A4F45948B265BB52A90C356DEEDDBBF7C89123A379B67D6DAEEB4F0F349A1F52BFDDF84AFB8D6E0F6FDF48C7470DBA7B1DEFDF145007DBD5DE3F28F6A1DB8AF68EBC5B2F5E7F8BCE8E6FE3D9D2918F732F1EC4D62A64FB75DB52BDCDA2D7FF789E23CABBD908EA763B15DE5C902DDF8DBBE705BDB603303EFA2F24437DA3A0974F9ECAFA9BFA3BD48F830BEBFAF9B54147FD518DC7B6FCB5E576C7C7B6DCEED04FE7DE4EC776BC7923DDEEDC7BFB7D6720F6A1DBA2F68E7CDFBE8F76ECC5EBA3BD23DFBB776F56C645EFC5F3DB72910C7A426DED3E51EA7F6CCF11E5DD3082BAED5D90DD8AB3F1F51E778EB2E711EB168094F45F4886FACBB47FF0F9CF671B1FC1F3CC69735D7F2AFFE8DED73ED5BCA91E9B6DF956E3AFDD1EDEED27E679608F9FD2BC852D8C4277243D3AF28E1F3CD8DC9127D38BE7B79D3AC9594BDD4E99BEC51FABFEC7F91C51DE75C33EBE7D4BBA6355B77C2BE24E8E5BDD02908CFE0B49B55AAD542AC3F8D4CDAC8FB9FAEACAFAFAFA089E674E9B8BFD0FB6391A1B69BFD1EDCE6DADF30FDAFFCCFFD3BB77E46FB84FCE3DCCF943631FBA6DE9D891F7F88CFB7A479E522F9E5F9073A4EFE9D3F7A7B4D473DCFA1FF3734479D7865FB7796AB54759B62C042D778EB5E771EB168034E45A489696963E7CC30DC9BFB059FB79477262A0D1D63A9C686CA4FD46C78777FC4AFB9F39B7D0FCD78EB71BFB99730F734E42EC43B75DED1D79D673F7A8DEC78E1F4FA917CF6F9BA5D2B7907A14766F11EB7FFCCF11E53D8243DCEDB8B72F0D1DCBB247C546D9F371A85B0012907721F9C0073F78F8F01D01A366D6CDECDAB52B6B6886FAF406B5B9AE3F39D0687E48FD76E32BED377A3FBCFD212D7FF6EBB69FEC7DB76E3FA5F71EE69C84D8872E803C1F54D83ED2E8C5F3DB66A90C7A360D7ACF28F55F8873A4E4E53D8243DCB7567B5FB79BEF30E2E21CE7BA05A0E8F22E241B1B1BD75E7B6DA8B70BAABF35E293274E0CF5B96DC1E6BAFEC440A3F921F5DB4D1D4387FB747B78E3B1DD369EF32BDD7E6EC7DBCD3BDC77577B4F42EC4317C6A01D7932BD787E5BAB90414FA56EB5DD3D49C6ACFFA29C23652EEFE11DD9FC85DDA3C2BB5DFF23EEF6F8D42D008536C042B2BABA9A05CE6E9FF73D50D4FCC0073F78E757BF36BC67B5655B4B9B2D5D6F9E88D8F15B1D73E340F132E7CF6D6E715A7E4AC9D3666D908E3CA55E3CBF21B5BF7D6B35FF3935FAFA2FD03952DAF28E9B36FB5ECCDBEFD0ED21A3DFF9D8870E80621B6C21C93A8F5DBB76DD73EF7D5B8E9A8F1D3F9E45D6F18C9AB5CD8EE4FCF9C7071ACD0FA9DF6EDF48C7CD36026AC77BB66F36E71672FEDC8E3FA5F7D67A4F42EC4317529E8E3CB15E3CBFAD5548FE9328CF777316EAC8EABF58E74839CB7B7847367F1DB65FED5BBE35D0F57F643B1FFBD001506C032F241B1B1B59A772D34D9F1DF4FFFFBC7CF2D41F7CFEF3F55FC71DC6330962735DFFBE31E848AF23E9DD91A7D78BE7E71C49E01C296179ABDB04EA168022DACA4252AD56B3B479CD3553597A6CBC6F61EFF1E5DB6ECBEEFFE94FFF4ED6C7047F0E016D7624ABC6A023C98EA45B479E642F9E9F73248D73A46CE5AD6ED3A85B000A67EB0BC9FAFAFA8D37DEB863C78E0F7CF08359986C7F3FFDEC2BB7DFFE3F3F7CC30DD97DF6EDFBE8DADA5AB8DD1E96CD8EE47BC6A023D58EA4BD234FB517CFCF3992CC3952AAF256B7C9D42D00C5B2DD85A45AAD2E2F2FCFCFCFEFDAB56BE28DB2AF645173696969636323C8BE8EC0E4E4E4ABAF3E7CFEFC778D8146C21D4973479E702F9E9F7324A573A43CE5AD6E53AA5B000AC442F206954AE5A9A7FEE2FCF9E3C64023ED8EA4DE913F79E244C2BD787ECE91C4CE919294B7BA4DAC6E01280A0BC91BCCCCCCFC9F23B79EAF3D66E41FDF5BFDB3A9A9A9D8876EB8B22E3CEB5613EEC5F3738EA4778E7CE0031F48BEBCD56D7A750B4021489B6F70F0E0C185858F455FE38B35FE64F173F3F3F3B10FDDD095E139E6E11C49EF1C29C3EB57EA36BDBA05A010D26F3206B2B6B63635F5ABAF561F3C5F7BD4C8396667DFB7BCBC1CFBD00D5D193AF23C9C23E99D2365A86D759B5EDD025008E93719833A70C1FEF3B5EF1879C6FF5AFA8F737333B10FDA2894A123CFC93992D8395292DA56B789D52D0085508A266320D56A75CF9EDF387AF47FD46A8F18BDC7FAFADD5353BFBAB1714FEC83360A25E9C8F3708E24768E94A4B6D56D62750B402194A2C918D4EAEAEAF4F435ABABCBB5DA31A3DBC8DA91AC755B59F952ECC3352225E9C873728EA4748E94A7B6D56D4A750B402194A5C918D4D1A347B3A6E4E0C17F59AB3D6CB48FE5E5CF4F4D555656FE5BEC03353AE5E9C873728E24738E94AAB6D56D32750B402194A8C91854B55A5D5898DFB3E7BD8B8BFF6E7DFDEBB5DA43C6C6C65F2D2DFD87B9B9BDB3B37BB2DBB10FD14895AA23CFC93992C63952B6DA56B769D42D008550AE26630B565656E6E7FFD9CE9DBF34C1C4C48E1D97CFCDBD3F6B4A621F9608264AD691E7E71C6956C47364A294B5AD6E9B15B16E01288432361905E573CFE29A2865474E19A8EDB85CDB01489826A318EEBFFFFEAC23DCD8D888BD23E5A52327556A3B2EF30F40C22C72C570D55557651DC96FFFF66FC7DE91F2D211922AB51D97F907206116B902F8C33FFCC3FA7FAD79C73BDE71ECD8B1D8BB53523A4252A5B6E332FF0024CC2237EE363636262727EB69F3D24B2F7DEF7BDF1B7B8F4A4A4748AAD4765CE61F808459E4C6DDECEC6CF33B075E75D5558B8B8BB177AA8C7484A44A6DC765FE014898456EAC6D6C6CB4BF55FD3BDFF9CE6AB51A7BD74A474748AAD4765CE61F808459E4C6DA97BEF4A57AC27CF7BBDFDD489BBFFEEBBFBEB2B2127BD74A474748AAD4765CE61F808459E4C6DAB7BEF5ADB7BDED6D954A65C78E1D5947B273D3DBDFFE766973F47484A44A6DC765FE014898456EDC1D3B766C6D6DADF68B8E24BBED6D69A3D011922AB51D97F907206116B9C2D091C465FE4995DA8ECBFC0390308B5C61E848E232FFA44A6DC765FE01489845AE30742471997F52A5B6E332FF0024CC2257183A92B8CC3FA952DB71997F001266912B0C1D495CE69F54A9EDB8CC3F0009B3C815868E242EF34FAAD4765CE61F808459E40A43471297F927556A3B2EF30F40C22C7285A12389CBFC932AB51D97F907206116B9C2D091C465FE4995DA8ECBFC0390308B5C61E848E232FFA44A6DC765FE01489845AE30742471997F52A5B6E332FF0024CC2257183A92B8CC3FA952DB71997F001266912B0C1D495CE69F54A9EDB8CC3F0009B3C815868E242EF34FAAD4765CE61F808459E40A4347125794F977D01901651697F907206116B9C2D091C4D57BFE27FAC973B7BEF719FA93A49494565CE61F808459E40A434712D7A0F3DFF1FE3D36D2F2ADE6BF3AF40C95028BCBFC0390308B5C61E848E20A98363BBE68D9ED5B5EDE64D8D4555CE61F808459E40A434712D740F3DFEDCE395FDB6CBF9BA3CFF0A8AEB8CC3F0009B3C815868E24AEFCF3DFF27265FB467ABCB6D9BC05AF6A321AAA2B2EF30F40C22C7285A123892BE7FCB744C78EFF1BB3EF17BDB6C928A9AEB8CC3F0009B3C815868E24AE3CF3DF3164B6DFCE9336BDB6C9C8A8AEB8CC3F0009B3C815868E24AEDEF3DF12083BE6C95A53B0ECFD9BB4397F2804A1CCE232FF0024CC2257183A92B846F62E41DD7E17570130244A2B2EF30F40C22C7285A123892B56DAECF14508425DC565FE01489845AE307424710D2F6DE67C67DA41F70172525771997F001266912B0C1D495CE69F54A9EDB8CC3F0009B3C815868E242EF34FAAD4765CE61F808459E40A43471297F927556A3B2EF30F40C22C7285A12389CBFC932AB51D97F907206116B9C2D091C465FE4995DA8ECBFC0390308B5C61E848E232FFA44A6DC765FE01489845AE30742471997F52A5B6E332FF0024CC2257183A92B8CC3FA952DB71997F001266912B0C1D495CE69F54A9EDB8CC3F0009B3C815868E242EF34FAAD4765CE61F808459E40A4347327A4B4B4BD9B44F4E4E4E4F4F673776EEDC99FDF9D6B7BE75757535F6AE4130AE2D71997F001266912B0C1DC9E87DE52B5F996873FDF5D72F2F2FC7DE3508C6B5252EF30F40C22C7285A12319BD6AB57AD965973547CDF7BCE73D3B77EEDCD8D888BD6B108C6B4B5CE61F808459E40A434712C5673EF39937BFF9CD8DB4F9A94F7D6A616121F64E4148AE2D71997F001266912B0C1D492C575E79653D6ADE70C30D954AA55AADC6DE2308C9B5252EF30F40C22C7285A12389E59BDFFCE625975C92CDFFCCCC8CFFB1497A5C5BE232FF0024CC2257183A9288DEF7BEF7D5D366EC1D81F05C5BE232FF0024CC2257183A9288D6D7D7B3F9F7C12724C9B5252EF30F40C22C7285A12389CBFC932AB51D97F907206116B9C228674752AD56979696E6E6E6F6ECD953A954DA3FFDB224B2E79ECDC0ECECECE2E2A2CF5F21AC89525E5BC687F907206116B9C228614772E4C8912C656551F3F6DB6FBFEBEEBB9F3C71E2CCD9B3E51CD973CF66E0F0E1C3FBF6EDCBE624CB9CB10F0EE928E1B565AC987F001266912B8C5275241B1B1BF3F3F37BF7EE7DE6D967CE9C3D63348FE75F783ECB9CD9E4ACAFAFC73E50A4A054D7963164FE01489845AE30CAD3916451737A7AFACBB77DE9CCD9D346B771E757EFBCF6DA6BD7D6D6621F2E0AAF3CD796F164FE01489845AE30CAD391CCCFCF6F46CDD78CDEE3AEBBBF7EDD75FF28F6E1A2F0CA736D194FE61F808459E40AA3241DC9912347F6EE7DFFD9735523CFF8DDDFFBD737DFFCFBB10F1AC556926BCBD832FF0024CC22571865E848AAD56AA55279F6B9B5B3E75E35F28C93A77EB66BD77B7C1028DB51866BCB3833FF0024CC22571865E848161717E7E7E7CF9E7BA531AE9FF9A7393F23A4F951A51A37DFFCEF171616621F3A0AAC0CD7967166FE01489845AE30CAD091CCCECE1EBEE37FFF6DD47CFFDEBFA9D59E7EBDF6C4D9DA774FD71E395D7BF0E4B943777CE32F9E7BE9FE33B5FF5BADDD5FADDDF34AEDEBAFD5FEE89E473FB1FF93D1835F94F1ED878E4E4F4FC73E74145819AE2DE3CCFC0390308B5C6194A123999A9A3A7EFCE1B3E74ED547F6944FD66AA7CED75E3A57FBE999DA2BB5DABFFA379F9D78D3DB76BF7FF6B9B3B5674ED79E79ADB656AD3D79AEF6A77FFDC8E6CB9BA74A384E9E7A71727232F6A1A3C0CA706D1967E61F808459E40AA30C1DC98E1D3B5E78F1B9B3E74ED647F6945F79BD76FAF50BDF3A77FEC29F7FF6B53FFF7B7FFF1FFCDBCFFDC1B95AEDE573B597CED67E7AB6B651AB7DFD81EF6CA6CD93E51C65A80D8647FDC465FE01489845AE30CAD0916C26C6971B23FBEBA973B5175FAD9D79FDE777D8D8D8F8CF5FF8E3DFFF4F5F78E647EBD95FCF9EAF9DD94CA1F77DFB9196C7966A94A136181EF51397F907206116B9C2284347B29918FF5F635C489BAFD79E7FA5F6E393B5B3B5DA99D3A7A7AEB96662E2E28989C90FFD8B7DCD0F7CF0A1875B1E5BAA5186DA6078D44F5CE61F808459E40AA30C1DC966627CA931EABF49FBE2ABB51FBD5CFBC96BB5078FFFE0CA2BAFBCF8CD97BEE58A5F9EFBC81BD2E603DF7EA8E5B1A51A65A80D8647FDC465FE01489845AE30CAD0916C26C68DC6C8FEFAEAF9DA4FAB175EDB7CFEB5DADD0FACBE7BD77B7FF9EFBEFD8A1D7FE78FFFFB9FBE56AB9D3C5D7BE5F48507DE73F48196C7966A94A1361892F5F5F59D3B77C6DE8B5273FE0290308B5C6194A123C99EE3B9733F6B8CFA53CE02E74B676B3F3B53FBD1CB67EF7B746DD73FFC8DEBFFF13FF9C9E9DA8FABB59F546B2F9EAE6579F39EFB1F68796CA946196A8321595B5BAB542AB1F7A2D49CBF0024CC22571865E8485A12E39EEBAFFBCEF79E78F0D1D5A3C756EF7D68F5DE871FBFEF3B27FEF2FEEFFEF5A34F7DF3A1C7BFF5D0F7EF7DF8FB471F79FCD1277E78CB7FBDEDC3377C387AEA9336299C23478ECCCCCCC4DE8B5273FE0290308B5C6194A123D94C9B3F6D1EBFF55B9F9CC8E19F7FE8432D0F2CD528436D30240736C5DE8B5273FE0290308B5C6194A123D94C9B2F1A838E32D4064332333373E4C891D87B516ACE5F001266912B8C32742417D2E6EB2F18838E32D406C3B0BEBE5EA954AAD56AEC1D2935E72F0009B3C81546193A92CDB4F9BC31E828436D300C870E1DBAF1C61B63EF45D9397F01489845AE30CAD0916CA6CD9F18838E32D406C155ABD54AA5B2BEBE1E7B47CACEF90B40C22C728551868E64336DFED8187494A136086E7E7E7E717131F65E508A6B3B00A565912B8C3274249B6973DD187474AB8DA5A5A5B5B5B5D11E438AE1D0A143FBF7EF8FBD175C50866B3B00A565912B8C327424D26690B4B9B1B1F1918F7CA4FED930EF78C73B044E9A55ABD5F9F97951737C94E1DA0E406959E40AA30C1DC966DAFC1B63D0D15C1BB7DE7AEBE4E4643D6A663776EEDCE93FE651B7B1B171E8D0A14AA5E21768C74A19AEED00949645AE30CAD09164CFF1F5D77F640C3AEAB5B1BABAFA6BBFF66B134D76EFDE9D458BD84795C85656560E1E3C383B3B9B15C38D37DEE85F1FC64D19AEED00949645AE30CAD0916CA6CDE78C4147366F7BF6EC99804EB2DA585858585E5EDED8D8887D8AD3C14409AEED00949645AE30CAD0914C5C489BCF1A838E7A6DACADADFDE66FFEE6AFFCCAAF3462C6E5975F3E3D3D1DFBA81259192E1D85E6000190308B5C6194A123D94C9BCF841DCDDBECF8CA4F8F3BE7DC6C8F2F0EE31975FCB98D393C72E4C8D5575FFDCE77BEB3FEEC2EBBECB26AB51AF198925FDF5729F3DCADEF7DE23D3F3A735000489845AE30CAD0916C66B31F061F8DCDB66FBFFE954E11F4872D7FEDB6CD9C1BECB69D504FB0791AB37879E0C081ABAEBA6A7A7A3AFBF3D8B163B10E28DBD4F1ACEF712968F956F35FCB700129288706808459E40AA30C1DC9F0F258B7D8D972A3392BB6A7CA1EAF17F5FD89C37E5EED93B9B6B6B6B8B8B8BCBC3CFAE348283DD266C7172DBB7DABFD9E8C0F4704808459E40AA30C1DC966367B7A78A3BEFDA688F874E327B6A5C7A75BEE90F376F317DBB739BCE715FBD0115EB7C3DAE3704FF47C31539D8C27C705808459E40AA30C1DC98548767E2DECF879D2FBC5ED6E371AF76CF94ACBA67ADF6E7978FB168634CA501B65D3F27265CBB76A3D5FDB6CDE42FB7D18378E0B0009B3C81546193A92CD6CF654F0D1D86CC7FEBBF93EDDFEECF1F0E68D343FAAF7DD823FC1D8878E905AA263CBF1ED98423BA6CD8E9B65DC382E0024CC22571865E84836F3D80F828FC666DBB75FFF4AFB1D9AEFD9FB8B79EEDCF147877D82B10F1DC1740C99EDB7F3A4CD7643DD73B6C67101206116B9C2284347B219C94E041F8DCDD66F34BDD2D8FA95EEAF49BE613B796E77DBC8909E60EC4347002D81B0639EAC3505CBF624D9B11294C798738000489845AE30CAD0916C46B227838FC666EB37DAFFEC76FFF6AF778FA39D7F56DF6D867A82B10F1DE1753BAC3D0E777B22EDF875C68A830240C22C728551868E6433923D117CFC22103ED1F8B3E52B8DBB35DFBFF96E2D77C873BB53220DFFD41A3F2BF6A123BC8069B3C71789CE1101206116B9C228434732BCB4D91E0B7B07C5FCDBEC9D6CFBDE5FDAA49B81D266E31F355AEED0F24F1E3D364B2C8E080009B3C81546193A92EC399E3FFFF89046CBC61BFD77F3ED6EFA6EADFDEBCD77E8B691804F2DF6A103B6C8F90B40C22C728551868E6433927DDF187494A1362055CE5F001266912B8C3274249B6973D5187494A1362055CE5F001266912B8C3274249B69F37BC6A0A30CB501A972FE0290308B5C6194A123999C9C7CF5D587CF9FFFAE31D028436D40AA9CBF0024CC22571865E8482A95CA534FFDC5F9F3C78D8146196A0352E5FC05206116B9C2284347323333F37F8EDC7ABEF698917F7C6FF5CFA6A6A6621F3A608BCA706D07A0B42C728551868EE4E0C1830B0B1F8B9EDF8A35FE64F173F3F3F3B10F1DB04565B8B603505A16B9C2284347B2B6B63635F5ABAF561F3C5F7BD4C8396667DFB7BCBC1CFBD0015B54866B3B00A565912B8C927424072ED87FBEF61D23CFF85F4BFF716E6E26F64103B6AE24D77600CAC922571825E948AAD5EA9E3DBF71F4E8FFA8D51E317A8FF5F5BBA7A67E7563E39ED8070DD8BA925CDB0128278B5C6194A723595D5D9D9EBE667575B9563B66741B59D4CC62F9CACA97621F2E605BCA736D07A0842C728551AA8EE4E8D1A359E03C78F05FD66A0F1BED6379F9F35353959595FF16FB4001DB55AA6B3B006563912B8CB27524D56A7561617ECF9EF72E2EFEBBF5F5AFD76A0F191B1B7FB5B4F41FE6E6F6CECEEEC96EC73E44400065BBB603502A16B9C2286747B2B2B2323FFFCF76EEFCA509262676ECB87C6EEEFD59E08C7D588060264A796D07A0242C7285A12389CB675A02C3E0DA0E40C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C7285A12389CBFC03C3E0DA0240C22C728531684732D124CFA6B6F3C554BBA5A5A5A5ECA94D4E4E4E4F4F673776EEDC99FDF9D6B7BE75757535F6AE018948F5FA09003569B340FA7624136F94F33E7DEFDFE3EB135D0CF0ACC6DB57BEF295F66777FDF5D72F2F2FC7DE352011295D3301A08545AE3006EA48F2DFB9E30B9583C6C854BBA56AB57AD9659735CFC07BDEF39E9D3B776E6C6CC4DE35A0C0FCDE0400259166484852EF44D723223607C5E68D345E9FECF183BADDEEF173077F6663ED339FF9CC9BDFFCE6C6B3FBD4A73EB5B0B0107BA78062F37B130094446AD920617D835CCE94D81232F324D296DBEDA932BD90D9ECCA2BAFAC3FE51B6EB8A152A954ABD5D87B04149BDF9B00A024520E0989C99336FBBEB0D9FEF5F65738FB6EA7F951BDEF96866F7EF39B975C7249F6BC666666BCF20004E1F726002883D48241C2F2A4CDBEB7BB7D37CF633BDE2EC98B9CEF7BDFFBEA6933F68E00E9F07B1300242FCD6C90A4EDBFB6D97E9F5A88B499F60B9B75EBEBEBD953F3061E40407E6F0280E4A5990D92345090EB7DE7BEAF6DE649AD1D7F50AA69B396F4530362F17B1300A44D035D18A15EDBECF167FB0FF2DA66DDC6C6C6FCFCBC37F000C2F27B1300A42DCD6C90A4EDBFB6D9FE8264B79728FBFED0965FC4DDDA4E16451632AFBBEEBA2FDF76DB9E3D7B044E20AC242F9B005067912B8CBEBF1CDB5BCB3D6BDD5FB7CCF3433BC6D4245FDBAC47CD07BFFDD099B3E7B23F054E609BAAD5EAF2F2F2810307666767F7FCC2CCCC4CF695C5C5C5F5F5F5D83B0800C1A4960D12363939E91D0B47AC396AD687C0096C591632B384D9F71F07A7A7A76FBDF556177C0012206D1646A552595B5B8BBD1725D21E35054E606B56565676EFDEDD376736CBAEF9DEA81680A293360B637A7AFAD8B163B1F7A22CBA454D81131848B55A9D9F9F6F7FF5F2777FF7F70E1FBEE3AEBBBFD11837DDF4D9BD7BF7B6DC737676D6A50680E292360B238B372B2B2BB1F7A2147A474D8113C8697D7DBDE525CD4F7FFA779E3C71A2C7B5E5F9175EFCE22DB7ECDCB9B3F9454EFFD4084041499B85313F3FBFB8B8187B2FD297276A0A9C405F6B6B6B59506C84C6999999DE39B32573DE74D3671B8F9D9C9C3C7AF468EC2704000393360B238B9A59E08CBD1789CB1F35054EA0876AB5DAFCAAE6E76EBE39E755A579DC7EFBFFCC7266E3154E6F570B40E1489B85B1BABA3A3535157B2F523668D41438816EE6E6E61A51F3F0E13BB610351B57981D3B76D4B7935D6A623F2D00188CB45924DE286878B61635054EA0DDF2F2F2365FD56C1E777EF56B8DAD1D3A7428F693038001489B4592F51937DE7863ECBD48507BD4CCDABB6BAE99EAF69FAC9E7FE1C55DBB767DF9B6DB044EA0DDF4F474E3FF6A6E336AD647E3FF70EEDCB9D3E770025020D26691644D86FFBA135CC7A859FFBF52575F5D690F9CF5A859EFFC044EA0C5D2D252E3AD7D9E79F6B92069F3E593A71AEF52EBDF1C01281069B360565656FCD79D807A44CDBA96C0D91C35054EA05D7611687CD84990A8591FD9A5A6BED91D3B76C47E8A009097B4593C070E1CF06FDB41B447CDE61710DA03677BD46C7FF942E08432CBCEFDC6C521D40B9B8D915D8BEA5BF6D9CB001485B459480B0B0B33333322CD76747B5BA0E677806C0E9C0F3DFC70C7A879E757BFD6BE05811312B6B4B4B4B6B6D6F15B8B8B8BF58B437611081B35B3F1894F7CB2BEF16C0918ED3306802D92368BEAC89123954AE5C08103FE1BE716F47E07DA8E81F3D24B2FCD1335054E48DBE38F3F5EBF025C7EF9E5870F1F6EF9EEFEFDFBEBDFDDFE5BD1B68FBBEEFE467DE3BB77EF8EF2DC016050D266816561264B9B59E69C9999C96EF8DDAA9CF27CD849C7C099336A0A9C90B06AB5FAA637BDA97E1DB8E4924BDEF5AE7735BFCE995D8DEBDFEA7D7DD8DA78F2C489FAC6B3CB7EBC09008001489B8597B53E478E1CC9D266E3AD29E821FFE76AF6089C7DA3A6C009096BF9DFDD6F79CB5B3EF6B18FD53F98A4F1D9275BFBF0DEBEA3F14363CF0100E462C5A25CB2A879D7DDDFC8D9D8FDE5CA5F5D7CF1C52D51F3A28B2EBAEDB63FC9FF9B6F7B36854CCCC0B86A04D16E9FD6BBCDD1D87EEC4B2900E462C5A25C8E1D3B9605CEE75F78B16F57D7F11D68EB3A7E0E67C72D643933FB89B19F3463AA2533F48E103903468FBBD5BFD552CCF9F69437B8E28A2B1A1338BB293BD3575757B36F4D4D4DD5BFFED8F1E3C3489B8DCF678A3D0700908B158BD2C913387B44CD9C8153D4A4AFDE69B3EFCB68ED0FE9BD9DF6EF0A2D5BD0F88C932C587EFCE31FCFFE5C5A5A6A7CB7F18B0CF97F8722FFC8AE2AF58DFBC84D008A42AB4119F50E9C1DA3E645175D943F708A9AF4D51CFF3A26C96EF7EFF8F51E89B4FDC7F5DD263D3CFDF4D3939393333333954A656161A1E53F66CFCFCFD767FE8BB7DC123C6D3E76FC787DE3D3D3D3B19E3E000C44AB4149750B9C1DA366D65CFED17FF942C7CFE16C0F9CA2267DE5CC7EDD3264EFE4D9F727F6DD0EBD2D2F2F2F2E2E76FCC8CD83070FD62776DFBE8F064F9B9FBBF9E6FAC6E7E6E646FEA401602BB41A94577BE0EC1635EBEF40DBF15D6A5B02A7A8491E1DC35EC7B4D9F776B72F768C97DBDC6DFA5A5D5DAD4F7576AD78F9E4A9B06933BB5ED5379E65DDD84F140072D17C506AED8173DFBE8F768C9AF5D11E38F7EEDDDBE829454D06D2F7F5C6BEB7BB6DA1C7A6BADD81502A954A7D6E0F1FBE2360D46C7CD8E6C4E62739C57E9600908B5683B2EB11383B7EAE6673E01435D9B23C49AF5B86EC9642BBFD88811EC5362D2C2CD4677BD7AE5D015FDEFCC0073F58DFECECEC6CECA70800796938A073E0EC18359B03A7A8C996B5E4C6BEAF37E67929B2B1A95AA7DFAA6DF9BAB4393C1B1B1B8D4FC5FCDCCD3707899AF7DC7B5FA3065C670028100D075CD01E38B348D9A3F97BECF8715193507ABFEAD82346E6B95B7BCEEC9D6CD9BE43870E357E3F62FB1F85F2E489138DF8BA7FFFFED84F0E0006A0D5809FCBF3399CED43D464CBDA5F72AC757A59B2DB8D8E5FEF9D39BBFD95E076EFDE5D3FBE5950ECFDD9BCBDC7CB274F35DEBA2CDBD4FAFA7AEC67060003D070C0DF1A34708A9A6C4DFBFFA26C7FBDB1FD3EED0FEF9645A5CDE8D6D6D61AFFC13B4B89BD7F57A2DB78E6D9E71A5173727272656525F6D30280C16838E00DF2074E5193507AFF266DEFAF777B78C7B03AD1C936779E6EB270D898E42C2B7EF1965B06FDBF9A8D5FA0CD1C3A7428F613028081E933A0559EC0296A027D2D2F2F377F66D2AE5DBBBABDF758CB4B9A1FBEE186E67F11103501282869133AE81D38454D20A7D5D5D5A9A9A9E6E89865CE9B6EFAEC63C78FB787CC2FDE72CBDEBD7B9BEF9C8555BF400B4071499BD059B7C0296A0203D9D8D83870E0C0E4E464C7DF64BEF6DA6BBB7D6B6E6ECEDB02015068D22674D51E38454D606BB2DC383F3FDF3155B6CBAE33478F1E8DBDCB00B05DD226F4D21C38454D609BAAD5EAD2D252163BA7A7A75B1266A552999D9DBDF5D65BBD9E094032A44DE8A31E389F3C7142D4040080FCA44DE82F0B99954A45D4040080FCA44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C29336010000084FDA040000203C6913000080F0A44D000000C2933601000008EFFF0320016C4A104809070000000049454E44AE426082, '0'), ('addf830df1bd4457b2e76eb564b31326', '1', 'leave.bpmn20.xml', '9285364c4fb44bdab52c0a7a7e9200c8', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22636F6D2E7468696E6B67656D2E6A6565736974652E6D6F64756C65732E6F612E6C65617665223E0A20203C70726F636573732069643D226C6561766522206E616D653D22E8AFB7E58187E6B581E7A88B2220697345786563757461626C653D2274727565223E0A202020203C646F63756D656E746174696F6E3EE8AFB7E58187E6B581E7A88BE6BC94E7A4BA3C2F646F63756D656E746174696F6E3E0A202020203C73746172744576656E742069643D2273746172746576656E743122206E616D653D225374617274222061637469766974693A696E69746961746F723D226170706C79557365724964223E3C2F73746172744576656E743E0A202020203C757365725461736B2069643D22646570744C6561646572417564697422206E616D653D22E983A8E997A8E9A286E5AFBCE5AEA1E689B9222061637469766974693A63616E64696461746547726F7570733D226F613A6C656176653A646570744C65616465724175646974223E3C2F757365725461736B3E0A202020203C6578636C7573697665476174657761792069643D226578636C7573697665676174657761793522206E616D653D224578636C75736976652047617465776179223E3C2F6578636C7573697665476174657761793E0A202020203C757365725461736B2069643D226D6F646966794170706C7922206E616D653D22E8B083E695B4E794B3E8AFB7222061637469766974693A61737369676E65653D22247B6170706C795573657249647D223E3C2F757365725461736B3E0A202020203C757365725461736B2069643D226872417564697422206E616D653D22E4BABAE4BA8BE5AEA1E689B9222061637469766974693A63616E64696461746547726F7570733D226F613A6C656176653A68724175646974223E3C2F757365725461736B3E0A202020203C6578636C7573697665476174657761792069643D226578636C7573697665676174657761793622206E616D653D224578636C75736976652047617465776179223E3C2F6578636C7573697665476174657761793E0A202020203C757365725461736B2069643D227265706F72744261636B22206E616D653D22E99480E58187222061637469766974693A61737369676E65653D22247B6170706C795573657249647D223E3C2F757365725461736B3E0A202020203C656E644576656E742069643D22656E646576656E743122206E616D653D22456E64223E3C2F656E644576656E743E0A202020203C6578636C7573697665476174657761792069643D226578636C7573697665676174657761793722206E616D653D224578636C75736976652047617465776179223E3C2F6578636C7573697665476174657761793E0A202020203C73657175656E6365466C6F772069643D22666C6F77322220736F757263655265663D2273746172746576656E743122207461726765745265663D22646570744C65616465724175646974223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77332220736F757263655265663D22646570744C6561646572417564697422207461726765745265663D226578636C75736976656761746577617935223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F773422206E616D653D22E4B88DE5908CE6848F2220736F757263655265663D226578636C7573697665676174657761793522207461726765745265663D226D6F646966794170706C79223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B21646570744C6561646572506173737D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F773522206E616D653D22E5908CE6848F2220736F757263655265663D226578636C7573697665676174657761793522207461726765745265663D2268724175646974223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B646570744C6561646572506173737D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77362220736F757263655265663D226872417564697422207461726765745265663D226578636C75736976656761746577617936223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F773722206E616D653D22E5908CE6848F2220736F757263655265663D226578636C7573697665676174657761793622207461726765745265663D227265706F72744261636B223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B6872506173737D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77382220736F757263655265663D227265706F72744261636B22207461726765745265663D22656E646576656E7431223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F773922206E616D653D22E4B88DE5908CE6848F2220736F757263655265663D226578636C7573697665676174657761793622207461726765745265663D226D6F646966794170706C79223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B216872506173737D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313022206E616D653D22E9878DE696B0E794B3E8AFB72220736F757263655265663D226578636C7573697665676174657761793722207461726765745265663D22646570744C65616465724175646974223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B72654170706C797D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F7731312220736F757263655265663D226D6F646966794170706C7922207461726765745265663D226578636C75736976656761746577617937223E3C2F73657175656E6365466C6F773E0A202020203C73657175656E6365466C6F772069643D22666C6F77313222206E616D653D22E7BB93E69D9FE6B581E7A88B2220736F757263655265663D226578636C7573697665676174657761793722207461726765745265663D22656E646576656E7431223E0A2020202020203C636F6E646974696F6E45787072657373696F6E207873693A747970653D2274466F726D616C45787072657373696F6E223E3C215B43444154415B247B2172654170706C797D5D5D3E3C2F636F6E646974696F6E45787072657373696F6E3E0A202020203C2F73657175656E6365466C6F773E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F6C65617665223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D226C65617665222069643D2242504D4E506C616E655F6C65617665223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D2273746172746576656E7431222069643D2242504D4E53686170655F73746172746576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233352E30222077696474683D2233352E302220783D2231302E302220793D2239302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22646570744C65616465724175646974222069643D2242504D4E53686170655F646570744C65616465724175646974223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D2239302E302220793D2238302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226578636C75736976656761746577617935222069643D2242504D4E53686170655F6578636C75736976656761746577617935223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2234302E30222077696474683D2234302E302220783D223235302E302220793D2238372E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226D6F646966794170706C79222069643D2242504D4E53686170655F6D6F646966794170706C79223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223231382E302220793D223139302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D2268724175646974222069643D2242504D4E53686170655F68724175646974223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223335382E302220793D2238302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226578636C75736976656761746577617936222069643D2242504D4E53686170655F6578636C75736976656761746577617936223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2234302E30222077696474683D2234302E302220783D223439352E302220793D2238372E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D227265706F72744261636B222069643D2242504D4E53686170655F7265706F72744261636B223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223539302E302220793D2238302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22656E646576656E7431222069643D2242504D4E53686170655F656E646576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233352E30222077696474683D2233352E302220783D223632352E302220793D223238332E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D226578636C75736976656761746577617937222069643D2242504D4E53686170655F6578636C75736976656761746577617937223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2234302E30222077696474683D2234302E302220783D223235302E302220793D223238302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7732222069643D2242504D4E456467655F666C6F7732223E0A20202020202020203C6F6D6764693A776179706F696E7420783D2234352E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D2239302E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7733222069643D2242504D4E456467655F666C6F7733223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223139352E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223235302E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7734222069643D2242504D4E456467655F666C6F7734223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223237302E302220793D223132372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223237302E302220793D223139302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2233362E302220783D2231302E302220793D22302E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7735222069643D2242504D4E456467655F666C6F7735223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223239302E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223335382E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D222D32342E302220793D222D31372E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7736222069643D2242504D4E456467655F666C6F7736223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223436332E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223439352E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7737222069643D2242504D4E456467655F666C6F7737223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223533352E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223539302E302220793D223130372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2232342E302220783D222D32322E302220793D222D31372E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7738222069643D2242504D4E456467655F666C6F7738223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223634322E302220793D223133352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223634322E302220793D223238332E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7739222069643D2242504D4E456467655F666C6F7739223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223531352E302220793D223132372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223531342E302220793D223231372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223332332E302220793D223231372E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2233362E302220783D2231302E302220793D22302E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773130222069643D2242504D4E456467655F666C6F773130223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223235302E302220793D223330302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223134322E302220793D223239392E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223134322E302220793D223133352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2234382E302220783D2231302E302220793D22302E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773131222069643D2242504D4E456467655F666C6F773131223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223237302E302220793D223234352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223237302E302220793D223238302E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F773132222069643D2242504D4E456467655F666C6F773132223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223239302E302220793D223330302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223632352E302220793D223330302E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C62706D6E64693A42504D4E4C6162656C3E0A202020202020202020203C6F6D6764633A426F756E6473206865696768743D2231342E30222077696474683D2234382E302220783D2231302E302220793D22302E30223E3C2F6F6D6764633A426F756E64733E0A20202020202020203C2F62706D6E64693A42504D4E4C6162656C3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, '0');
COMMIT;

-- ----------------------------
-- Table structure for act_ge_property
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_property`;
CREATE TABLE `act_ge_property` (
`NAME_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`VALUE_`  varchar(300) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`NAME_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_ge_property
-- ----------------------------
BEGIN;
INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', '1'), ('schema.history', 'create(5.13) upgrade(5.13->5.14)', '2'), ('schema.version', '5.14', '2');
COMMIT;

-- ----------------------------
-- Table structure for act_hi_actinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_actinst`;
CREATE TABLE `act_hi_actinst` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`PROC_DEF_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`EXECUTION_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`ACT_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`CALL_PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`ACT_NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`ACT_TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`ASSIGNEE_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`START_TIME_`  datetime NOT NULL ,
`END_TIME_`  datetime NULL DEFAULT NULL ,
`DURATION_`  bigint(20) NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
INDEX `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`) USING BTREE ,
INDEX `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`) USING BTREE ,
INDEX `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`, `ACT_ID_`) USING BTREE ,
INDEX `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`, `ACT_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_hi_actinst
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
`USER_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DESCRIPTION_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`URL_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`CONTENT_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_hi_attachment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_comment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_comment`;
CREATE TABLE `act_hi_comment` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TIME_`  datetime NOT NULL ,
`USER_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`ACTION_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`MESSAGE_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`FULL_MSG_`  longblob NULL ,
PRIMARY KEY (`ID_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_hi_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_detail
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_detail`;
CREATE TABLE `act_hi_detail` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EXECUTION_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`ACT_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`VAR_TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
`TIME_`  datetime NOT NULL ,
`BYTEARRAY_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DOUBLE_`  double NULL DEFAULT NULL ,
`LONG_`  bigint(20) NULL DEFAULT NULL ,
`TEXT_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TEXT2_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
INDEX `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`) USING BTREE ,
INDEX `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`) USING BTREE ,
INDEX `ACT_IDX_HI_DETAIL_TIME` (`TIME_`) USING BTREE ,
INDEX `ACT_IDX_HI_DETAIL_NAME` (`NAME_`) USING BTREE ,
INDEX `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_hi_detail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_identitylink`;
CREATE TABLE `act_hi_identitylink` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`GROUP_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`USER_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
INDEX `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`) USING BTREE ,
INDEX `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`) USING BTREE ,
INDEX `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_hi_identitylink
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`BUSINESS_KEY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_DEF_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`START_TIME_`  datetime NOT NULL ,
`END_TIME_`  datetime NULL DEFAULT NULL ,
`DURATION_`  bigint(20) NULL DEFAULT NULL ,
`START_USER_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`START_ACT_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`END_ACT_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`SUPER_PROCESS_INSTANCE_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DELETE_REASON_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
UNIQUE INDEX `PROC_INST_ID_` (`PROC_INST_ID_`) USING BTREE ,
UNIQUE INDEX `ACT_UNIQ_HI_BUS_KEY` (`PROC_DEF_ID_`, `BUSINESS_KEY_`) USING BTREE ,
INDEX `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`) USING BTREE ,
INDEX `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_hi_procinst
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`PROC_DEF_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_DEF_KEY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EXECUTION_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PARENT_TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DESCRIPTION_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`OWNER_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`ASSIGNEE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`START_TIME_`  datetime NOT NULL ,
`CLAIM_TIME_`  datetime NULL DEFAULT NULL ,
`END_TIME_`  datetime NULL DEFAULT NULL ,
`DURATION_`  bigint(20) NULL DEFAULT NULL ,
`DELETE_REASON_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PRIORITY_`  int(11) NULL DEFAULT NULL ,
`DUE_DATE_`  datetime NULL DEFAULT NULL ,
`FORM_KEY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_hi_taskinst
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EXECUTION_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`VAR_TYPE_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
`BYTEARRAY_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DOUBLE_`  double NULL DEFAULT NULL ,
`LONG_`  bigint(20) NULL DEFAULT NULL ,
`TEXT_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TEXT2_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
INDEX `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`) USING BTREE ,
INDEX `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`, `VAR_TYPE_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_hi_varinst
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_id_group
-- ----------------------------
DROP TABLE IF EXISTS `act_id_group`;
CREATE TABLE `act_id_group` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`REV_`  int(11) NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_id_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_id_info
-- ----------------------------
DROP TABLE IF EXISTS `act_id_info`;
CREATE TABLE `act_id_info` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`REV_`  int(11) NULL DEFAULT NULL ,
`USER_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TYPE_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`KEY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`VALUE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PASSWORD_`  longblob NULL ,
`PARENT_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_id_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_id_membership
-- ----------------------------
DROP TABLE IF EXISTS `act_id_membership`;
CREATE TABLE `act_id_membership` (
`USER_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`GROUP_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
PRIMARY KEY (`USER_ID_`, `GROUP_ID_`),
FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `ACT_FK_MEMB_GROUP` (`GROUP_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_id_membership
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_id_user
-- ----------------------------
DROP TABLE IF EXISTS `act_id_user`;
CREATE TABLE `act_id_user` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`REV_`  int(11) NULL DEFAULT NULL ,
`FIRST_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`LAST_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EMAIL_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PWD_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PICTURE_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_id_user
-- ----------------------------
BEGIN;
INSERT INTO `act_id_user` VALUES ('1', '1', null, null, null, null, null), ('1faa22c1be314b139827ee6e8019f476', '1', null, null, null, null, null), ('2', '1', null, null, null, null, null);
COMMIT;

-- ----------------------------
-- Table structure for act_re_deployment
-- ----------------------------
DROP TABLE IF EXISTS `act_re_deployment`;
CREATE TABLE `act_re_deployment` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`CATEGORY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DEPLOY_TIME_`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
PRIMARY KEY (`ID_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_re_deployment
-- ----------------------------
BEGIN;
INSERT INTO `act_re_deployment` VALUES ('9285364c4fb44bdab52c0a7a7e9200c8', 'SpringAutoDeployment', null, '2014-09-05 10:44:33');
COMMIT;

-- ----------------------------
-- Table structure for act_re_model
-- ----------------------------
DROP TABLE IF EXISTS `act_re_model`;
CREATE TABLE `act_re_model` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`KEY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`CATEGORY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`CREATE_TIME_`  timestamp NULL DEFAULT NULL ,
`LAST_UPDATE_TIME_`  timestamp NULL DEFAULT NULL ,
`VERSION_`  int(11) NULL DEFAULT NULL ,
`META_INFO_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DEPLOYMENT_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EDITOR_SOURCE_VALUE_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EDITOR_SOURCE_EXTRA_VALUE_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`) USING BTREE ,
INDEX `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) USING BTREE ,
INDEX `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_re_model
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_re_procdef
-- ----------------------------
DROP TABLE IF EXISTS `act_re_procdef`;
CREATE TABLE `act_re_procdef` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
`CATEGORY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`KEY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`VERSION_`  int(11) NOT NULL ,
`DEPLOYMENT_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`RESOURCE_NAME_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DGRM_RESOURCE_NAME_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DESCRIPTION_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`HAS_START_FORM_KEY_`  tinyint(4) NULL DEFAULT NULL ,
`SUSPENSION_STATE_`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
UNIQUE INDEX `ACT_UNIQ_PROCDEF` (`KEY_`, `VERSION_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_re_procdef
-- ----------------------------
BEGIN;
INSERT INTO `act_re_procdef` VALUES ('leave:1:002c595d6dc5486e83f9f74972eab0e9', '1', 'com.thinkgem.jeesite.modules.oa.leave', '请假流程', 'leave', '1', '9285364c4fb44bdab52c0a7a7e9200c8', 'leave.bpmn20.xml', 'leave.png', '请假流程演示', '0', '1');
COMMIT;

-- ----------------------------
-- Table structure for act_ru_event_subscr
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_event_subscr`;
CREATE TABLE `act_ru_event_subscr` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
`EVENT_TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`EVENT_NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EXECUTION_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`ACTIVITY_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`CONFIGURATION_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`CREATED_`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
PRIMARY KEY (`ID_`),
FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`) USING BTREE ,
INDEX `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_ru_event_subscr
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_execution
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_execution`;
CREATE TABLE `act_ru_execution` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`REV_`  int(11) NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`BUSINESS_KEY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PARENT_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_DEF_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`SUPER_EXEC_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`ACT_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`IS_ACTIVE_`  tinyint(4) NULL DEFAULT NULL ,
`IS_CONCURRENT_`  tinyint(4) NULL DEFAULT NULL ,
`IS_SCOPE_`  tinyint(4) NULL DEFAULT NULL ,
`IS_EVENT_SCOPE_`  tinyint(4) NULL DEFAULT NULL ,
`SUSPENSION_STATE_`  int(11) NULL DEFAULT NULL ,
`CACHED_ENT_STATE_`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `ACT_UNIQ_RU_BUS_KEY` (`PROC_DEF_ID_`, `BUSINESS_KEY_`) USING BTREE ,
INDEX `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`) USING BTREE ,
INDEX `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`) USING BTREE ,
INDEX `ACT_FK_EXE_PARENT` (`PARENT_ID_`) USING BTREE ,
INDEX `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_ru_execution
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_identitylink`;
CREATE TABLE `act_ru_identitylink` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`REV_`  int(11) NULL DEFAULT NULL ,
`GROUP_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`USER_ID_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_DEF_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`) USING BTREE ,
INDEX `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`) USING BTREE ,
INDEX `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`) USING BTREE ,
INDEX `ACT_FK_TSKASS_TASK` (`TASK_ID_`) USING BTREE ,
INDEX `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_ru_identitylink
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_job`;
CREATE TABLE `act_ru_job` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
`TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`LOCK_EXP_TIME_`  timestamp NULL DEFAULT NULL ,
`LOCK_OWNER_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EXCLUSIVE_`  tinyint(1) NULL DEFAULT NULL ,
`EXECUTION_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROCESS_INSTANCE_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_DEF_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`RETRIES_`  int(11) NULL DEFAULT NULL ,
`EXCEPTION_STACK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`EXCEPTION_MSG_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DUEDATE_`  timestamp NULL DEFAULT NULL ,
`REPEAT_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`HANDLER_TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`HANDLER_CFG_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_ru_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_task
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_task`;
CREATE TABLE `act_ru_task` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' ,
`REV_`  int(11) NULL DEFAULT NULL ,
`EXECUTION_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_DEF_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PARENT_TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DESCRIPTION_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_DEF_KEY_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`OWNER_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`ASSIGNEE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DELEGATION_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PRIORITY_`  int(11) NULL DEFAULT NULL ,
`CREATE_TIME_`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`DUE_DATE_`  datetime NULL DEFAULT NULL ,
`SUSPENSION_STATE_`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`) USING BTREE ,
INDEX `ACT_FK_TASK_EXE` (`EXECUTION_ID_`) USING BTREE ,
INDEX `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`) USING BTREE ,
INDEX `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_ru_task
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_variable
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_variable`;
CREATE TABLE `act_ru_variable` (
`ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`REV_`  int(11) NULL DEFAULT NULL ,
`TYPE_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`NAME_`  varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`EXECUTION_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`PROC_INST_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TASK_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`BYTEARRAY_ID_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`DOUBLE_`  double NULL DEFAULT NULL ,
`LONG_`  bigint(20) NULL DEFAULT NULL ,
`TEXT_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
`TEXT2_`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL ,
PRIMARY KEY (`ID_`),
FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`) USING BTREE ,
INDEX `ACT_FK_VAR_EXE` (`EXECUTION_ID_`) USING BTREE ,
INDEX `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`) USING BTREE ,
INDEX `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_bin

;

-- ----------------------------
-- Records of act_ru_variable
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cms_article
-- ----------------------------
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`category_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '栏目编号' ,
`title`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题' ,
`link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章链接' ,
`color`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题颜色' ,
`image`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章图片' ,
`keywords`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字' ,
`description`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述、摘要' ,
`weight`  int(11) NULL DEFAULT 0 COMMENT '权重，越大越靠前' ,
`weight_date`  datetime NULL DEFAULT NULL COMMENT '权重期限' ,
`hits`  int(11) NULL DEFAULT 0 COMMENT '点击数' ,
`posid`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '推荐位，多选' ,
`custom_content_view`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义内容视图' ,
`view_config`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '视图配置' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `cms_article_create_by` (`create_by`) USING BTREE ,
INDEX `cms_article_title` (`title`) USING BTREE ,
INDEX `cms_article_keywords` (`keywords`) USING BTREE ,
INDEX `cms_article_del_flag` (`del_flag`) USING BTREE ,
INDEX `cms_article_weight` (`weight`) USING BTREE ,
INDEX `cms_article_update_date` (`update_date`) USING BTREE ,
INDEX `cms_article_category_id` (`category_id`) USING BTREE ,
INDEX `cms_article_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='文章表'

;

-- ----------------------------
-- Records of cms_article
-- ----------------------------
BEGIN;
INSERT INTO `cms_article` VALUES ('1', '3', '文章标题标题标题标题', null, 'green', null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('10', '4', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('11', '5', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('12', '5', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('13', '5', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('14', '7', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('15', '7', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('16', '7', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('17', '7', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('18', '8', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('19', '8', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('2', '3', '文章标题标题标题标题', null, 'red', null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('20', '8', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('21', '8', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('22', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('23', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('24', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('25', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('26', '9', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('27', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('28', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('29', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('3', '3', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('30', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('31', '11', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('32', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('33', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('34', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('35', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('36', '12', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('37', '13', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('38', '13', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('39', '13', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('4', '3', '文章标题标题标题标题', null, 'green', null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('40', '13', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('41', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('42', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('43', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('44', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('45', '14', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('46', '15', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('47', '15', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('48', '15', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('49', '16', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('5', '3', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('50', '17', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('51', '17', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('52', '26', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('53', '26', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('6', '3', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('7', '4', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('8', '4', '文章标题标题标题标题', null, 'blue', null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('9', '4', '文章标题标题标题标题', null, null, null, '关键字1,关键字2', null, '0', null, '0', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for cms_article_data
-- ----------------------------
DROP TABLE IF EXISTS `cms_article_data`;
CREATE TABLE `cms_article_data` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`content`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文章内容' ,
`copyfrom`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章来源' ,
`relation`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相关文章' ,
`allow_comment`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否允许评论' ,
PRIMARY KEY (`id`),
INDEX `cms_article_data_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='文章详表'

;

-- ----------------------------
-- Records of cms_article_data
-- ----------------------------
BEGIN;
INSERT INTO `cms_article_data` VALUES ('1', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('10', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('11', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('12', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('13', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('14', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('15', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('16', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('17', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('18', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('19', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('2', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('20', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('21', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('22', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('23', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('24', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('25', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('26', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('27', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('28', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('29', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('3', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('30', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('31', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('32', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('33', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('34', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('35', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('36', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('37', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('38', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('39', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('4', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('40', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('41', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('42', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('43', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('44', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('45', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('46', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('47', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('48', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('49', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('5', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('50', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('51', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('52', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('53', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('6', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('7', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('8', '文章内容内容内容内容', '来源', '1,2,3', '1'), ('9', '文章内容内容内容内容', '来源', '1,2,3', '1');
COMMIT;

-- ----------------------------
-- Table structure for cms_category
-- ----------------------------
DROP TABLE IF EXISTS `cms_category`;
CREATE TABLE `cms_category` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`site_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '站点编号' ,
`office_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '归属机构' ,
`parent_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父级编号' ,
`parent_ids`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '所有父级编号' ,
`module`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '栏目模块' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '栏目名称' ,
`image`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '栏目图片' ,
`href`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接' ,
`target`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目标' ,
`description`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述' ,
`keywords`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字' ,
`sort`  int(11) NULL DEFAULT 30 COMMENT '排序（升序）' ,
`in_menu`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '是否在导航中显示' ,
`in_list`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '是否在分类页中显示列表' ,
`show_modes`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '展现方式' ,
`allow_comment`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否允许评论' ,
`is_audit`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否需要审核' ,
`custom_list_view`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义列表视图' ,
`custom_content_view`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义内容视图' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
`view_config`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '视图配置' ,
PRIMARY KEY (`id`),
INDEX `cms_category_parent_id` (`parent_id`) USING BTREE ,
INDEX `cms_category_module` (`module`) USING BTREE ,
INDEX `cms_category_name` (`name`) USING BTREE ,
INDEX `cms_category_sort` (`sort`) USING BTREE ,
INDEX `cms_category_del_flag` (`del_flag`) USING BTREE ,
INDEX `cms_category_office_id` (`office_id`) USING BTREE ,
INDEX `cms_category_site_id` (`site_id`) USING BTREE ,
INDEX `cms_category_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='栏目表'

;

-- ----------------------------
-- Records of cms_category
-- ----------------------------
BEGIN;
INSERT INTO `cms_category` VALUES ('1', '0', '1', '0', '0,', null, '顶级栏目', null, null, null, null, null, '0', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('10', '1', '4', '1', '0,1,', 'article', '软件介绍', null, null, null, null, null, '20', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('11', '1', '4', '10', '0,1,10,', 'article', '网络工具', null, null, null, null, null, '30', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('12', '1', '4', '10', '0,1,10,', 'article', '浏览工具', null, null, null, null, null, '40', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('13', '1', '4', '10', '0,1,10,', 'article', '浏览辅助', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('14', '1', '4', '10', '0,1,10,', 'article', '网络优化', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('15', '1', '4', '10', '0,1,10,', 'article', '邮件处理', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('16', '1', '4', '10', '0,1,10,', 'article', '下载工具', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('17', '1', '4', '10', '0,1,10,', 'article', '搜索工具', null, null, null, null, null, '50', '1', '1', '2', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('18', '1', '5', '1', '0,1,', 'link', '友情链接', null, null, null, null, null, '90', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('19', '1', '5', '18', '0,1,18,', 'link', '常用网站', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('2', '1', '3', '1', '0,1,', 'article', '组织机构', null, null, null, null, null, '10', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('20', '1', '5', '18', '0,1,18,', 'link', '门户网站', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('21', '1', '5', '18', '0,1,18,', 'link', '购物网站', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('22', '1', '5', '18', '0,1,18,', 'link', '交友社区', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('23', '1', '5', '18', '0,1,18,', 'link', '音乐视频', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('24', '1', '6', '1', '0,1,', null, '百度一下', null, 'http://www.baidu.com', '_blank', null, null, '90', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('25', '1', '6', '1', '0,1,', null, '全文检索', null, '/search', null, null, null, '90', '0', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('26', '2', '6', '1', '0,1,', 'article', '测试栏目', null, null, null, null, null, '90', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('27', '1', '6', '1', '0,1,', null, '公共留言', null, '/guestbook', null, null, null, '90', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('3', '1', '3', '2', '0,1,2,', 'article', '网站简介', null, null, null, null, null, '30', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('4', '1', '3', '2', '0,1,2,', 'article', '内部机构', null, null, null, null, null, '40', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('5', '1', '3', '2', '0,1,2,', 'article', '地方机构', null, null, null, null, null, '50', '1', '1', '0', '0', '1', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('6', '1', '3', '1', '0,1,', 'article', '质量检验', null, null, null, null, null, '20', '1', '1', '1', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('7', '1', '3', '6', '0,1,6,', 'article', '产品质量', null, null, null, null, null, '30', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('8', '1', '3', '6', '0,1,6,', 'article', '技术质量', null, null, null, null, null, '40', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null), ('9', '1', '3', '6', '0,1,6,', 'article', '工程质量', null, null, null, null, null, '50', '1', '1', '0', '1', '0', null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0', null);
COMMIT;

-- ----------------------------
-- Table structure for cms_comment
-- ----------------------------
DROP TABLE IF EXISTS `cms_comment`;
CREATE TABLE `cms_comment` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`category_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '栏目编号' ,
`content_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '栏目内容的编号' ,
`title`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '栏目内容的标题' ,
`content`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论内容' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论姓名' ,
`ip`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论IP' ,
`create_date`  datetime NOT NULL COMMENT '评论时间' ,
`audit_user_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核人' ,
`audit_date`  datetime NULL DEFAULT NULL COMMENT '审核时间' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `cms_comment_category_id` (`category_id`) USING BTREE ,
INDEX `cms_comment_content_id` (`content_id`) USING BTREE ,
INDEX `cms_comment_status` (`del_flag`) USING BTREE ,
INDEX `cms_comment_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='评论表'

;

-- ----------------------------
-- Records of cms_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cms_guestbook
-- ----------------------------
DROP TABLE IF EXISTS `cms_guestbook`;
CREATE TABLE `cms_guestbook` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`type`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '留言分类' ,
`content`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '留言内容' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名' ,
`email`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱' ,
`phone`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话' ,
`workunit`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单位' ,
`ip`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'IP' ,
`create_date`  datetime NOT NULL COMMENT '留言时间' ,
`re_user_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复人' ,
`re_date`  datetime NULL DEFAULT NULL COMMENT '回复时间' ,
`re_content`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复内容' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `cms_guestbook_del_flag` (`del_flag`) USING BTREE ,
INDEX `cms_site_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='留言板'

;

-- ----------------------------
-- Records of cms_guestbook
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cms_link
-- ----------------------------
DROP TABLE IF EXISTS `cms_link`;
CREATE TABLE `cms_link` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`category_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '栏目编号' ,
`title`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '链接名称' ,
`color`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题颜色' ,
`image`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接图片' ,
`href`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接地址' ,
`weight`  int(11) NULL DEFAULT 0 COMMENT '权重，越大越靠前' ,
`weight_date`  datetime NULL DEFAULT NULL COMMENT '权重期限' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `cms_link_category_id` (`category_id`) USING BTREE ,
INDEX `cms_link_title` (`title`) USING BTREE ,
INDEX `cms_link_del_flag` (`del_flag`) USING BTREE ,
INDEX `cms_link_weight` (`weight`) USING BTREE ,
INDEX `cms_link_create_by` (`create_by`) USING BTREE ,
INDEX `cms_link_update_date` (`update_date`) USING BTREE ,
INDEX `cms_link_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='友情链接'

;

-- ----------------------------
-- Records of cms_link
-- ----------------------------
BEGIN;
INSERT INTO `cms_link` VALUES ('1', '19', 'JeeSite', null, null, 'http://thinkgem.github.com/jeesite', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('10', '22', '58同城', null, null, 'http://www.58.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('11', '23', '视频大全', null, null, 'http://v.360.cn/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('12', '23', '凤凰网', null, null, 'http://www.ifeng.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('2', '19', 'ThinkGem', null, null, 'http://thinkgem.iteye.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('3', '19', '百度一下', null, null, 'http://www.baidu.com', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('4', '19', '谷歌搜索', null, null, 'http://www.google.com', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('5', '20', '新浪网', null, null, 'http://www.sina.com.cn', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('6', '20', '腾讯网', null, null, 'http://www.qq.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('7', '21', '淘宝网', null, null, 'http://www.taobao.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('8', '21', '新华网', null, null, 'http://www.xinhuanet.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('9', '22', '赶集网', null, null, 'http://www.ganji.com/', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for cms_site
-- ----------------------------
DROP TABLE IF EXISTS `cms_site`;
CREATE TABLE `cms_site` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '站点名称' ,
`title`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '站点标题' ,
`logo`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站点Logo' ,
`domain`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站点域名' ,
`description`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述' ,
`keywords`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字' ,
`theme`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'default' COMMENT '主题' ,
`copyright`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '版权信息' ,
`custom_index_view`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义站点首页视图' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `cms_site_del_flag` (`del_flag`) USING BTREE ,
INDEX `cms_site_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='站点表'

;

-- ----------------------------
-- Records of cms_site
-- ----------------------------
BEGIN;
INSERT INTO `cms_site` VALUES ('1', '默认站点', 'JeeSite Web', null, null, 'JeeSite', 'JeeSite', 'basic', 'Copyright &copy; 2012-2013 <a href=\'http://thinkgem.iteye.com\' target=\'_blank\'>ThinkGem</a> - Powered By <a href=\'https://github.com/thinkgem/jeesite\' target=\'_blank\'>JeeSite</a> V1.0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('2', '子站点测试', 'JeeSite Subsite', null, null, 'JeeSite subsite', 'JeeSite subsite', 'basic', 'Copyright &copy; 2012-2013 <a href=\'http://thinkgem.iteye.com\' target=\'_blank\'>ThinkGem</a> - Powered By <a href=\'https://github.com/thinkgem/jeesite\' target=\'_blank\'>JeeSite</a> V1.0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for demo1_student_score
-- ----------------------------
DROP TABLE IF EXISTS `demo1_student_score`;
CREATE TABLE `demo1_student_score` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`stu_name`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`courses`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`score`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=13

;

-- ----------------------------
-- Records of demo1_student_score
-- ----------------------------
BEGIN;
INSERT INTO `demo1_student_score` VALUES ('1', '张三', '语文', '74'), ('2', '张三', '数学', '83'), ('3', '张三', '物理', '93'), ('4', '李四', '语文', '74'), ('5', '李四', '数学', '84'), ('6', '李四', '物理', '94'), ('7', '王五', '语文', '75'), ('8', '王五', '数学', '86'), ('9', '王五', '物理', '95'), ('10', '赵六', '语文', '72'), ('11', '赵六', '数学', '89'), ('12', '赵六', '物理', '91');
COMMIT;

-- ----------------------------
-- Table structure for oa_leave
-- ----------------------------
DROP TABLE IF EXISTS `oa_leave`;
CREATE TABLE `oa_leave` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`process_instance_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程实例编号' ,
`start_time`  datetime NULL DEFAULT NULL COMMENT '开始时间' ,
`end_time`  datetime NULL DEFAULT NULL COMMENT '结束时间' ,
`leave_type`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假类型' ,
`reason`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假理由' ,
`apply_time`  datetime NULL DEFAULT NULL COMMENT '申请时间' ,
`reality_start_time`  datetime NULL DEFAULT NULL COMMENT '实际开始时间' ,
`reality_end_time`  datetime NULL DEFAULT NULL COMMENT '实际结束时间' ,
`process_status`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程状态' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `oa_leave_create_by` (`create_by`) USING BTREE ,
INDEX `oa_leave_process_instance_id` (`process_instance_id`) USING BTREE ,
INDEX `oa_leave_del_flag` (`del_flag`) USING BTREE ,
INDEX `oa_leave_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='请假流程表'

;

-- ----------------------------
-- Records of oa_leave
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for prj_project
-- ----------------------------
DROP TABLE IF EXISTS `prj_project`;
CREATE TABLE `prj_project` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称' ,
`root_package`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '包名' ,
`erm_path`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据文件路径' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '删除标志' ,
PRIMARY KEY (`id`),
INDEX `prj_project_id` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='项目'

;

-- ----------------------------
-- Records of prj_project
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_area
-- ----------------------------
DROP TABLE IF EXISTS `sys_area`;
CREATE TABLE `sys_area` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`parent_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父级编号' ,
`parent_ids`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '所有父级编号' ,
`code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域编码' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称' ,
`type`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域类型' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `sys_area_parent_id` (`parent_id`) USING BTREE ,
INDEX `sys_area_del_flag` (`del_flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='区域表'

;

-- ----------------------------
-- Records of sys_area
-- ----------------------------
BEGIN;
INSERT INTO `sys_area` VALUES ('1', '0', '0,', '100000', '中国', '1', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('10', '8', '0,1,2,', '370532', '历城区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('11', '8', '0,1,2,', '370533', '历城区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('12', '8', '0,1,2,', '370534', '历下区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('13', '8', '0,1,2,', '370535', '天桥区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('14', '8', '0,1,2,', '370536', '槐荫区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('2', '1', '0,1,', '110000', '北京市', '2', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('3', '2', '0,1,2,', '110101', '东城区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('4', '2', '0,1,2,', '110102', '西城区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('5', '2', '0,1,2,', '110103', '朝阳区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('6', '2', '0,1,2,', '110104', '丰台区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('7', '2', '0,1,2,', '110105', '海淀区', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('8', '1', '0,1,', '370000', '山东省', '2', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('9', '8', '0,1,2,', '370531', '济南市', '3', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`label`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标签名' ,
`value`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据值' ,
`type`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型' ,
`description`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述' ,
`sort`  int(11) NOT NULL COMMENT '排序（升序）' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `sys_dict_value` (`value`) USING BTREE ,
INDEX `sys_dict_label` (`label`) USING BTREE ,
INDEX `sys_dict_del_flag` (`del_flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='字典表'

;

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES ('0f0c4d06156d400798b3a25ad0c43111', '手机钱包', '1001', '17k_recharge', '手机钱包', '10', '2', '2014-09-05 13:19:19', '2', '2014-09-05 13:19:19', null, '0'), ('1', '正常', '0', 'del_flag', '删除标记', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('10', '黄色', 'yellow', 'color', '颜色值', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('11', '橙色', 'orange', 'color', '颜色值', '50', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('12', '默认主题', 'default', 'theme', '主题方案', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('13', '天蓝主题', 'cerulean', 'theme', '主题方案', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('14', '橙色主题', 'readable', 'theme', '主题方案', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('141553f11f844d2395cb2167ed89791a', '游戏点卡充值', '26', '17k_recharge', '游戏点卡充值', '10', '2', '2014-09-05 11:36:35', '2', '2014-09-05 11:36:35', null, '0'), ('15', '红色主题', 'united', 'theme', '主题方案', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('1598c9952fea40dfbcc7208f3f9e805f', 'wap350充值', '0', '17k_recharge', 'wap350充值', '10', '2', '2014-09-05 11:40:12', '2', '2014-09-05 11:40:12', null, '0'), ('16', 'Flat主题', 'flat', 'theme', '主题方案', '60', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('17', '国家', '1', 'sys_area_type', '区域类型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('18', '省份、直辖市', '2', 'sys_area_type', '区域类型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('19', '地市', '3', 'sys_area_type', '区域类型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('2', '删除', '1', 'del_flag', '删除标记', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('20', '区县', '4', 'sys_area_type', '区域类型', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('21', '公司', '1', 'sys_office_type', '机构类型', '60', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('2134513e964b43c49192d143bb6c6961', 'QQ币充值', '27', '17k_recharge', 'QQ币充值', '10', '2', '2014-09-05 11:36:51', '2', '2014-09-05 11:36:51', null, '0'), ('22', '部门', '2', 'sys_office_type', '机构类型', '70', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('23', '一级', '1', 'sys_office_grade', '机构等级', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('24', '二级', '2', 'sys_office_grade', '机构等级', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('25', '三级', '3', 'sys_office_grade', '机构等级', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('26', '四级', '4', 'sys_office_grade', '机构等级', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('27', '所有数据', '1', 'sys_data_scope', '数据范围', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('28', '所在公司及以下数据', '2', 'sys_data_scope', '数据范围', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('29', '所在公司数据', '3', 'sys_data_scope', '数据范围', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('292fcbef1ba342568161cabc1c09f4ac', '客户端AppStore充值', '34', '17k_recharge', '客户端AppStore充值', '10', '2', '2014-09-05 11:39:01', '2', '2014-09-05 11:39:01', null, '0'), ('2e089670278f49208314fbc4ed831455', '客户端联通充值', '33', '17k_recharge', '客户端联通充值', '10', '2', '2014-09-05 11:38:49', '2', '2014-09-05 11:38:49', null, '0'), ('3', '显示', '1', 'show_hide', '显示/隐藏', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('30', '所在部门及以下数据', '4', 'sys_data_scope', '数据范围', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('31', '所在部门数据', '5', 'sys_data_scope', '数据范围', '50', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('32', '仅本人数据', '8', 'sys_data_scope', '数据范围', '90', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('33', '按明细设置', '9', 'sys_data_scope', '数据范围', '100', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('34', '系统管理', '1', 'sys_user_type', '用户类型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('34c05ca69fd344a9856b0b4aaec2f356', '捷讯充值卡', '1002', '17k_recharge', '捷讯充值卡', '10', '2', '2014-09-05 13:19:34', '2', '2014-09-05 13:19:34', null, '0'), ('35', '部门经理', '2', 'sys_user_type', '用户类型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('36', '普通用户', '3', 'sys_user_type', '用户类型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('37', '基础主题', 'basic', 'cms_theme', '站点主题', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('38', '蓝色主题', 'blue', 'cms_theme', '站点主题', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('389346fa44a04cd6b6b7c5cc0b34716f', 'wap充值', '1', '17k_platform', 'wap充值', '10', '2', '2014-09-05 11:42:21', '2', '2014-09-05 11:42:21', null, '0'), ('39', '红色主题', 'red', 'cms_theme', '站点主题', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('3a499df219434143a1630c8ae6a5c004', '手机钱包充值2元', '13', '17k_recharge', '手机钱包充值2元', '10', '2', '2014-09-05 11:37:37', '2', '2014-09-05 11:37:37', null, '0'), ('3aa34c55e4384bd4b0d3ed55b2a2018c', '客户端Pp支付', '37', '17k_recharge', '客户端Pp支付', '10', '2', '2014-09-05 11:39:44', '2', '2014-09-05 11:39:44', null, '0'), ('3b761ad32ee34c139e66937576296e38', '联通一卡充', '23', '17k_recharge', '联通一卡充', '10', '2', '2014-09-05 11:36:20', '2', '2014-09-05 11:36:20', null, '0'), ('4', '隐藏', '0', 'show_hide', '显示/隐藏', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('40', '文章模型', 'article', 'cms_module', '栏目模型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('41', '图片模型', 'picture', 'cms_module', '栏目模型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('42', '下载模型', 'download', 'cms_module', '栏目模型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('43', '链接模型', 'link', 'cms_module', '栏目模型', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('44', '专题模型', 'special', 'cms_module', '栏目模型', '50', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('44fcfa276e47483aae95cc235c6ccadb', '17K充值卡充值', '6', '17k_recharge', '17K充值卡充值', '10', '2', '2014-09-05 11:35:11', '2', '2014-09-05 11:35:11', null, '0'), ('45', '默认展现方式', '0', 'cms_show_modes', '展现方式', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('46', '首栏目内容列表', '1', 'cms_show_modes', '展现方式', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('47', '栏目第一条内容', '2', 'cms_show_modes', '展现方式', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('48', '发布', '0', 'cms_del_flag', '内容状态', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('482f0736687e42de8e0c750ab667dc97', '财付通充值', '31', '17k_recharge', '财付通充值', '10', '2', '2014-09-05 11:37:23', '2', '2014-09-05 11:37:23', null, '0'), ('486ef24190a94e5a86a70acc548e6022', '支付宝充值', '12', '17k_recharge', '支付宝充值', '10', '2', '2014-09-05 11:35:31', '2', '2014-09-05 11:35:31', null, '0'), ('49', '删除', '1', 'cms_del_flag', '内容状态', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('5', '是', '1', 'yes_no', '是/否', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('50', '审核', '2', 'cms_del_flag', '内容状态', '15', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('51', '首页焦点图', '1', 'cms_posid', '推荐位', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('52', '栏目页文章推荐', '2', 'cms_posid', '推荐位', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('53', '咨询', '1', 'cms_guestbook', '留言板分类', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('54', '建议', '2', 'cms_guestbook', '留言板分类', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('55', '投诉', '3', 'cms_guestbook', '留言板分类', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('56', '其它', '4', 'cms_guestbook', '留言板分类', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('566fd3bedd2a418cb65fdd7fe68546be', '声讯充值', '29', '17k_recharge', '声讯充值', '10', '2', '2014-09-05 11:37:07', '2', '2014-09-05 11:37:07', null, '0'), ('57', '公休', '1', 'oa_leave_type', '请假类型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('58', '病假', '2', 'oa_leave_type', '请假类型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('581278ae8c72407d91db920d49062396', 'wap充值', '1', '17k_recharge', 'wap充值', '10', '2', '2014-09-05 11:40:26', '2', '2014-09-05 11:40:26', null, '0'), ('59', '事假', '3', 'oa_leave_type', '请假类型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('6', '否', '0', 'yes_no', '是/否', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('60', '调休', '4', 'oa_leave_type', '请假类型', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('60cb1682f7964f1e9403da8e5c59d6af', '客户端支付宝充值', '32', '17k_recharge', '客户端支付宝充值', '10', '2', '2014-09-05 11:38:36', '2', '2014-09-05 11:38:36', null, '0'), ('61', '婚假', '5', 'oa_leave_type', '请假类型', '60', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('62', '接入日志', '1', 'sys_log_type', '日志类型', '30', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0'), ('63', '异常日志', '2', 'sys_log_type', '日志类型', '40', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0'), ('64', '单表增删改查', 'single', 'prj_template_type', '代码模板', '10', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0'), ('65', '所有entity和dao', 'entityAndDao', 'prj_template_type', '代码模板', '20', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0'), ('6e0f6f4b4c654dd084995a58fd614247', 'www赠送', '-1', '17k_recharge', 'www赠送', '10', '2', '2014-09-05 11:39:57', '2', '2014-09-05 11:39:57', null, '0'), ('7', '红色', 'red', 'color', '颜色值', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('7561c87a58144c389264dc1ffde5f4e5', '网上银行充值', '2', '17k_recharge', '网上银行充值', '10', '2', '2014-09-05 11:34:50', '2', '2014-09-05 11:34:50', null, '0'), ('7a282ee3b7d341e0af146cf4f50bde8d', '手机钱包自动注册包月用户', '16', '17k_recharge', '手机钱包自动注册包月用户', '10', '2', '2014-09-05 11:38:19', '2', '2014-09-05 11:38:19', null, '0'), ('7b66a37373db41838124e57524350073', '客户端手机钱包充值2元', '35', '17k_recharge', '客户端手机钱包充值2元', '10', '2', '2014-09-05 11:39:15', '2', '2014-09-05 11:39:15', null, '0'), ('8', '绿色', 'green', 'color', '颜色值', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('8b78418f83df49f3bd49c0d5fa60fad4', '联通沃阅读', '1006', '17k_recharge', '联通沃阅读', '10', '2', '2014-09-05 13:20:36', '2', '2014-09-05 13:20:36', null, '0'), ('8e26c22f9e3a482f9e9370c035f2e012', '手机钱包自动注册', '15', '17k_recharge', '手机钱包自动注册', '10', '2', '2014-09-05 11:38:06', '2', '2014-09-05 11:38:06', null, '0'), ('9', '蓝色', 'blue', 'color', '颜色值', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('a698870543724c34bf8355fdc83d4f2f', '华健联通-电信', '1005', '17k_recharge', '华健联通-电信', '10', '2', '2014-09-05 13:20:20', '2', '2014-09-05 13:20:20', null, '0'), ('a906fd7b6baa4517804b69483f5bf069', '支付宝充值', '22', '17k_recharge', '支付宝充值', '10', '2', '2014-09-05 11:36:06', '2', '2014-09-05 11:36:06', null, '0'), ('ac9a22da4c844426bb74129a40dfa08b', '微信支付', '1007', '17k_recharge', '微信支付', '10', '2', '2014-09-05 13:20:49', '2', '2014-09-05 13:20:49', null, '0'), ('b046898cf1bd46a6aa867546a187b4a5', 'www充值', '0', '17k_platform', 'www充值', '10', '2', '2014-09-05 11:42:07', '2', '2014-09-05 11:42:07', null, '0'), ('d2fbbc87f6974b0a9b70e03b0773f696', '客户端手机钱包充值10元', '36', '17k_recharge', '客户端手机钱包充值10元', '10', '2', '2014-09-05 11:39:28', '2', '2014-09-05 11:39:28', null, '0'), ('d462216899eb41c78147c0095a207ca2', '华健联通-联通', '1004', '17k_recharge', '华健联通-联通', '10', '2', '2014-09-05 13:20:03', '2', '2014-09-05 13:20:03', null, '0'), ('d71839a1bee64aa099355841d5873ac1', '手机钱包充值10元', '14', '17k_recharge', '手机钱包充值10元', '10', '2', '2014-09-05 11:37:51', '2', '2014-09-05 11:37:51', null, '0'), ('f2dace5671bc4aa59f9139f6f67f1cf7', 'wap赠送', '16', '17k_recharge', 'wap赠送', '10', '2', '2014-09-05 11:40:38', '2', '2014-09-05 11:40:38', null, '0'), ('fb831f659ceb4b42814254ee0ecfcc40', '支付宝', '1003', '17k_recharge', '支付宝', '10', '2', '2014-09-05 13:19:48', '2', '2014-09-05 13:19:48', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`type`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '日志类型' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`remote_addr`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作IP地址' ,
`user_agent`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户代理' ,
`request_uri`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求URI' ,
`method`  varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作方式' ,
`params`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '操作提交的数据' ,
`exception`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '异常信息' ,
PRIMARY KEY (`id`),
INDEX `sys_log_create_by` (`create_by`) USING BTREE ,
INDEX `sys_log_request_uri` (`request_uri`) USING BTREE ,
INDEX `sys_log_type` (`type`) USING BTREE ,
INDEX `sys_log_create_date` (`create_date`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='日志表'

;

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES ('012e1d6f382a48e08df31f66a99a7e11', '1', '1', '2014-09-05 10:50:31', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/role/save', 'POST', 'id=1&office.id=1&office.name=北京市总公司&oldName=系统管理员&name=系统管理员&dataScope=1&menuIds=1,27,28,29,30,f16c9e4782df4920adb58bc620e6809a,1420b2b0e1ba4e4ebc8cd2f7daeaf300,8f6085c89bef4df1a...&officeIds=', ''), ('038d640ce7f24ed79a98ecc8f06b9c57', '1', '2', '2014-09-05 11:40:26', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1&label=wap充值&type=17k_recharge&description=wap充值&sort=10', ''), ('072609dfaaee47a0b0ad7adf09c78645', '1', '2', '2014-09-05 11:39:28', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=36&label=客户端手机钱包充值10元&type=17k_recharge&description=客户端手机钱包充值10元&sort=10', ''), ('09d9989a361541a8be60572ed02e0ddf', '1', '2', '2014-09-05 13:19:48', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1003&label=支付宝&type=17k_recharge&description=支付宝&sort=10', ''), ('0b3b97f14dc147f78788620468bdd735', '1', '2', '2014-09-05 11:37:51', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=14&label=手机钱包充值10元&type=17k_recharge&description=手机钱包充值10元&sort=10', ''), ('0bb65c588efd4c6d90911525d71e4566', '1', '1', '2014-09-18 16:28:49', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=13', ''), ('0e8531f4e76d45c58088d974094e1ca5', '1', '1', '2014-09-18 16:27:02', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/role/save', 'POST', 'id=5&office.id=1&office.name=北京市总公司&oldName=本部门管理员&name=本部门管理员&dataScope=5&menuIds=1,27,28,29,30,f16c9e4782df4920adb58bc620e6809a,1420b2b0e1ba4e4ebc8cd2f7daeaf300,8f6085c89bef4df1a...&officeIds=', ''), ('12d2019f019c4d45952720071d7e9c2f', '1', '2', '2014-09-05 13:19:34', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1002&label=捷讯充值卡&type=17k_recharge&description=捷讯充值卡&sort=10', ''), ('139ebb9375b542d494e54104638ef27c', '2', '1faa22c1be314b139827ee6e8019f476', '2014-09-18 16:45:01', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/stat/studentscore', 'GET', '', 'org.hibernate.exception.SQLGrammarException: could not extract ResultSet'), ('147a30dde7784b5299590f761ebed0d6', '1', '2', '2014-09-05 11:39:57', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=-1&label=www赠送&type=17k_recharge&description=www赠送&sort=10', ''), ('1497b3a296aa41de917c28c79e424e09', '1', '1', '2014-09-05 10:46:40', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/role/save', 'POST', 'id=1&office.id=1&office.name=北京市总公司&oldName=系统管理员&name=系统管理员&dataScope=1&menuIds=1,27,28,29,30,2,13,20,21,22,17,18,19,14,15,16,3,4,5,6,7,8,9,10,11,12,67,68&officeIds=', ''), ('1556a0e181304b69adc65e118285ce86', '1', '1', '2014-09-18 16:26:24', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/role/delete', 'GET', 'id=2', ''), ('18452406fe594f28b35d239e2558fbd2', '1', '2', '2014-09-05 11:35:11', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=6&label=17K充值卡充值&type=17k_recharge&description=17K充值卡充值&sort=10', ''), ('18da350040914c82a17b08c39fbe8cb3', '1', '1', '2014-09-05 10:46:05', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/delete', 'GET', 'id=23', ''), ('1ddb63f687d24c70a3620334c2c78013', '1', '2', '2014-09-05 13:20:36', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1006&label=联通沃阅读&type=17k_recharge&description=联通沃阅读&sort=10', ''), ('22830cba681f4d9d9ca55293df267e2d', '1', '1', '2014-09-05 10:49:26', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/save', 'POST', 'id=&parent.id=1420b2b0e1ba4e4ebc8cd2f7daeaf300&parent.name=充值分析&name=充值统计&href=/stat/recharge/&target=&icon=&sort=30&isShow=1&isActiviti=0&permission=', ''), ('23c097596e544c4a9367c39194f5203b', '1', '2', '2014-09-05 11:39:01', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=34&label=客户端AppStore充值&type=17k_recharge&description=客户端AppStore充值&sort=10', ''), ('2aac7470b0ef4421952d0f4c8a9a4476', '1', '1', '2014-09-18 16:24:25', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/menu/save', 'POST', 'id=f16c9e4782df4920adb58bc620e6809a&parent.id=1&parent.name=顶级菜单&name=学生成绩统计&href=&target=&icon=&sort=200&isShow=1&isActiviti=0&permission=', ''), ('2b47ba78c4624b37b4cb7bb3f22b6147', '1', '1', '2014-09-05 10:46:09', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/delete', 'GET', 'id=76', ''), ('2c665f1615e644e3b4795e2e40f122bd', '1', '2', '2014-09-05 11:35:31', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=12&label=支付宝充值&type=17k_recharge&description=支付宝充值&sort=10', ''), ('35786f40a3b8499f80b9bef45a01a540', '1', '2', '2014-09-05 11:34:50', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=2&label=网上银行充值&type=17k_recharge&description=网上银行充值&sort=10', ''), ('35cce283dc0f4f52b075fe2f7ea11be0', '1', '1', '2014-09-18 16:25:11', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/menu/save', 'POST', 'id=8f6085c89bef4df1a603752ef129da79&parent.id=1420b2b0e1ba4e4ebc8cd2f7daeaf300&parent.name=成绩分析&name=普通成绩统计&href=/stat/studentscore&target=&icon=&sort=30&isShow=1&isActiviti=0&permission=', ''), ('360d0b6cfb4c43cf92ca3df3567a1c58', '1', '1', '2014-09-05 10:45:44', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/delete', 'GET', 'id=62', ''), ('485aaf54ad0e4109bd20c4cfb190dd1f', '1', '1', '2014-09-18 16:24:36', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/menu/save', 'POST', 'id=1420b2b0e1ba4e4ebc8cd2f7daeaf300&parent.id=f16c9e4782df4920adb58bc620e6809a&parent.name=学生成绩统计&name=成绩分析&href=&target=&icon=&sort=30&isShow=1&isActiviti=0&permission=', ''), ('4dc9451c888044e4abd75dd48832d71d', '1', '1', '2014-09-18 16:27:20', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/role/save', 'POST', 'id=6&office.id=1&office.name=北京市总公司&oldName=普通用户&name=普通用户&dataScope=8&menuIds=1,27,28,29,30,f16c9e4782df4920adb58bc620e6809a,1420b2b0e1ba4e4ebc8cd2f7daeaf300,8f6085c89bef4df1a...&officeIds=', ''), ('508f695063f3414294aa5ef308a192ac', '1', '1', '2014-09-18 16:29:08', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=5', ''), ('50ecd137e86e4b1cb60dd1e205ecc621', '1', '1', '2014-09-18 16:29:10', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=4', ''), ('53d378e7877d494c853bbb2eb59999c3', '1', '1', '2014-09-18 16:28:53', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=14', ''), ('54ddcc8b99b343f9a5c6befa7026948b', '1', '2', '2014-09-05 11:38:49', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=33&label=客户端联通充值&type=17k_recharge&description=客户端联通充值&sort=10', ''), ('570e79de7799457fa49e364ad189988a', '1', '2', '2014-09-05 11:40:38', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=16&label=wap赠送&type=17k_recharge&description=wap赠送&sort=10', ''), ('57fb046f78e14605b9e62d54997621f1', '1', '2', '2014-09-05 11:38:19', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=16&label=手机钱包自动注册包月用户&type=17k_recharge&description=手机钱包自动注册包月用户&sort=10', ''), ('5d64761f7d5a4d009d74f074ad94cd35', '1', '1', '2014-09-18 16:28:12', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/role/save', 'POST', 'id=6&office.id=1&office.name=北京市总公司&oldName=普通用户&name=统计用户&dataScope=8&menuIds=1,27,28,29,30,f16c9e4782df4920adb58bc620e6809a,1420b2b0e1ba4e4ebc8cd2f7daeaf300,8f6085c89bef4df1a...&officeIds=', ''), ('64608bbbcad34c3d88fa07fe178b151b', '1', '2', '2014-09-05 11:39:15', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=35&label=客户端手机钱包充值2元&type=17k_recharge&description=客户端手机钱包充值2元&sort=10', ''), ('646dc585d6a640faa0ffb6cec923f473', '1', '1', '2014-09-18 16:29:03', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=7', ''), ('6847e845680f422c94de81deda231d79', '1', '1', '2014-09-18 16:28:43', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=11', ''), ('6bfc94f13630498c87a1631405c43caf', '1', '1', '2014-09-18 16:27:57', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/role/delete', 'GET', 'id=5', ''), ('6dae23c94a9c4a21879fd814144e454d', '1', '1', '2014-09-18 16:29:39', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/save', 'POST', 'id=&company.id=1&company.name=北京市总公司&office.id=1&office.name=北京市总公司&oldLoginName=&loginName=stat&no=001&name=stat&newPassword=&confirmNewPassword=&email=stat@163.com&phone=&mobile=&remarks=&userType=3&roleIdList=6&_roleIdList=on', ''), ('70a40da653ba467697c232deea7496b1', '1', '2', '2014-09-05 13:20:49', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1007&label=微信支付&type=17k_recharge&description=微信支付&sort=10', ''), ('762ff1c535c64e1784fb9c13886c8805', '1', '2', '2014-09-05 13:19:19', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1001&label=手机钱包&type=17k_recharge&description=手机钱包&sort=10', ''), ('76b449037f7b41aabb668a3d37598ef2', '1', '1', '2014-09-18 16:28:57', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=9', ''), ('79190f310fc84275b0ff5611c7f57612', '1', '2', '2014-09-05 11:36:06', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=22&label=支付宝充值&type=17k_recharge&description=支付宝充值&sort=10', ''), ('7bb476e586884487b9dd5ae3e6892564', '1', '2', '2014-09-05 11:38:06', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=15&label=手机钱包自动注册&type=17k_recharge&description=手机钱包自动注册&sort=10', ''), ('7bfa1e7b38734eaf9a0bf9563a0c0e9e', '1', '1', '2014-09-18 16:25:28', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/menu/save', 'POST', 'id=e166343cad0e4f3591ac325c6807d0f1&parent.id=8f6085c89bef4df1a603752ef129da79&parent.name=普通成绩统计&name=查看&href=&target=&icon=&sort=30&isShow=0&isActiviti=0&permission=stat:studentscore:view', ''), ('7e7a892241e0412290f1f3a326d7dd84', '1', '2', '2014-09-05 11:36:51', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=27&label=QQ币充值&type=17k_recharge&description=QQ币充值&sort=10', ''), ('887dc80d24964dc6822f286c86740e0a', '1', '1', '2014-09-05 10:48:04', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/save', 'POST', 'id=&parent.id=1&parent.name=顶级菜单&name=充值统计&href=&target=&icon=&sort=200&isShow=1&isActiviti=0&permission=', ''), ('8a829c12d2d348c0b60e0538cf8544ae', '1', '1', '2014-09-18 16:29:12', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=3', ''), ('8fa0c70b1a9040bb99098efc9dc02344', '1', '1', '2014-09-18 16:26:36', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/role/delete', 'GET', 'id=3', ''), ('90efc3aaabee4a4288835dbf6f4b5b29', '1', '1', '2014-09-18 16:27:59', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/role/delete', 'GET', 'id=4', ''), ('923c4daf6df8474fb3c77cbcfb1a43e8', '1', '2', '2014-09-05 11:37:37', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=13&label=手机钱包充值2元&type=17k_recharge&description=手机钱包充值2元&sort=10', ''), ('9348387c34d141e8afd59ac64a355051', '1', '2', '2014-09-05 13:20:03', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1004&label=华健联通-联通&type=17k_recharge&description=华健联通-联通&sort=10', ''), ('97120766a57d46948df6c373daf80e01', '1', '2', '2014-09-05 11:36:20', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=23&label=联通一卡充&type=17k_recharge&description=联通一卡充&sort=10', ''), ('98ce5647921d4f498a1f322ad688130f', '1', '1', '2014-09-05 10:50:14', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/save', 'POST', 'id=&parent.id=8f6085c89bef4df1a603752ef129da79&parent.name=充值统计&name=查看&href=&target=&icon=&sort=30&isShow=0&isActiviti=0&permission=stat:recharge:view', ''), ('99c73a09e2f64ceea7a8c14ce2debc02', '1', '1', '2014-09-05 10:48:33', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/save', 'POST', 'id=&parent.id=f16c9e4782df4920adb58bc620e6809a&parent.name=充值统计&name=充值分析&href=&target=&icon=&sort=30&isShow=1&isActiviti=0&permission=', ''), ('9aaeab3f69d14b4fa935d9b622261bb0', '1', '1', '2014-09-05 10:45:48', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/delete', 'GET', 'id=31', ''), ('a70c668306cd4293a6bb2e80cf1b5004', '1', '1', '2014-09-05 10:45:56', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/menu/delete', 'GET', 'id=69', ''), ('ab5fef49e2a840deb9230145b2267f4b', '1', '1', '2014-09-18 16:28:40', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=10', ''), ('bf987cb734e34eb7837ab129c492eb1a', '2', '1faa22c1be314b139827ee6e8019f476', '2014-09-18 16:29:48', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/stat/studentscore', 'GET', '', 'org.hibernate.exception.SQLGrammarException: could not extract ResultSet'), ('c55b79aaff3344ac8b3d6ab6107b4390', '1', '2', '2014-09-05 11:40:12', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=0&label=wap350充值&type=17k_recharge&description=wap350充值&sort=10', ''), ('c8bc2e450bd0458c9131696cc78a9916', '1', '1', '2014-09-18 16:29:06', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=6', ''), ('cf3abe3518c946a1b95863f7997e03b7', '1', '1', '2014-09-18 16:28:46', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=12', ''), ('d224c45d69da4a7d89a87cf085856593', '1', '2', '2014-09-05 11:42:21', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1&label=wap充值&type=17k_platform&description=wap充值&sort=10', ''), ('d29876d87e054ce9b75cbfed072f0b09', '1', '2', '2014-09-05 11:37:23', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=31&label=财付通充值&type=17k_recharge&description=财付通充值&sort=10', ''), ('d2b021cb0d734d74a3ecbe26562b8c43', '1', '2', '2014-09-05 11:38:36', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=32&label=客户端支付宝充值&type=17k_recharge&description=客户端支付宝充值&sort=10', ''), ('d4fe4115949b4e2b83158fd7c1092dc8', '1', '1', '2014-09-18 16:29:00', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/user/delete', 'GET', 'id=8', ''), ('d6eb4f09d9364f2f8e4db9537c7c0d13', '1', '2', '2014-09-05 11:39:44', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=37&label=客户端Pp支付&type=17k_recharge&description=客户端Pp支付&sort=10', ''), ('da203bd7fef149ac971f90296e704fe6', '1', '2', '2014-09-05 11:36:35', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=26&label=游戏点卡充值&type=17k_recharge&description=游戏点卡充值&sort=10', ''), ('db300968cf964bd89724f21950034a99', '1', '1', '2014-09-18 16:25:42', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/jeechart/a/sys/role/delete', 'GET', 'id=7', ''), ('e3dd127f586f4cf59edd3dccc91e8642', '1', '2', '2014-09-05 13:20:20', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=1005&label=华健联通-电信&type=17k_recharge&description=华健联通-电信&sort=10', ''), ('f09809b709964f39aaaa80861086c9d6', '1', '2', '2014-09-05 11:42:07', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=0&label=www充值&type=17k_platform&description=www充值&sort=10', ''), ('f6141017fa024491a0ab72200d653983', '1', '2', '2014-09-05 11:37:07', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1', '/stat.17k.com/a/sys/dict/save', 'POST', 'id=&value=29&label=声讯充值&type=17k_recharge&description=声讯充值&sort=10', '');
COMMIT;

-- ----------------------------
-- Table structure for sys_mdict
-- ----------------------------
DROP TABLE IF EXISTS `sys_mdict`;
CREATE TABLE `sys_mdict` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`parent_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父级编号' ,
`parent_ids`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '所有父级编号' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称' ,
`description`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述' ,
`sort`  int(11) NULL DEFAULT NULL COMMENT '排序（升序）' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `sys_mdict_parent_id` (`parent_id`) USING BTREE ,
INDEX `sys_mdict_del_flag` (`del_flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='多级字典表'

;

-- ----------------------------
-- Records of sys_mdict
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`parent_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父级编号' ,
`parent_ids`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '所有父级编号' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称' ,
`href`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接' ,
`target`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目标' ,
`icon`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标' ,
`sort`  int(11) NOT NULL COMMENT '排序（升序）' ,
`is_show`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '是否在菜单中显示' ,
`is_activiti`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否同步工作流' ,
`permission`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `sys_menu_parent_id` (`parent_id`) USING BTREE ,
INDEX `sys_menu_del_flag` (`del_flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='菜单表'

;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1', '0', '0,', '顶级菜单', null, null, null, '0', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('10', '3', '0,1,2,3,', '字典管理', '/sys/dict/', null, 'th-list', '60', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('11', '10', '0,1,2,3,10,', '查看', null, null, null, '30', '0', '0', 'sys:dict:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('12', '10', '0,1,2,3,10,', '修改', null, null, null, '30', '0', '0', 'sys:dict:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('13', '2', '0,1,2,', '机构用户', null, null, null, '970', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('14', '13', '0,1,2,13,', '区域管理', '/sys/area/', null, 'th', '50', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('1420b2b0e1ba4e4ebc8cd2f7daeaf300', 'f16c9e4782df4920adb58bc620e6809a', '0,1,f16c9e4782df4920adb58bc620e6809a,', '成绩分析', '', '', '', '30', '1', '0', '', '1', '2014-09-05 10:48:33', '1', '2014-09-18 16:24:36', null, '0'), ('15', '14', '0,1,2,13,14,', '查看', null, null, null, '30', '0', '0', 'sys:area:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('16', '14', '0,1,2,13,14,', '修改', null, null, null, '30', '0', '0', 'sys:area:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('17', '13', '0,1,2,13,', '机构管理', '/sys/office/', null, 'th-large', '40', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('18', '17', '0,1,2,13,17,', '查看', null, null, null, '30', '0', '0', 'sys:office:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('19', '17', '0,1,2,13,17,', '修改', null, null, null, '30', '0', '0', 'sys:office:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('2', '1', '0,1,', '系统设置', null, null, null, '900', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('20', '13', '0,1,2,13,', '用户管理', '/sys/user/', null, 'user', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('21', '20', '0,1,2,13,20,', '查看', null, null, null, '30', '0', '0', 'sys:user:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('22', '20', '0,1,2,13,20,', '修改', null, null, null, '30', '0', '0', 'sys:user:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('23', '2', '0,1,2,', '关于帮助', null, null, null, '990', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('24', '23', '0,1,2,23', '项目首页', 'http://jeesite.com', '_blank', null, '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('25', '23', '0,1,2,23', '项目支持', 'http://jeesite.com/donation.html', '_blank', null, '50', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('26', '23', '0,1,2,23', '论坛交流', 'http://bbs.jeesite.com', '_blank', null, '80', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('27', '1', '0,1,', '我的面板', null, null, null, '100', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('28', '27', '0,1,27,', '个人信息', null, null, null, '990', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('29', '28', '0,1,27,28,', '个人信息', '/sys/user/info', null, 'user', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('3', '2', '0,1,2,', '系统设置', null, null, null, '980', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('30', '28', '0,1,27,28,', '修改密码', '/sys/user/modifyPwd', null, 'lock', '40', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('31', '1', '0,1,', '内容管理', null, null, null, '500', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('32', '31', '0,1,31,', '栏目设置', null, null, null, '990', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('33', '32', '0,1,31,32', '栏目管理', '/cms/category/', null, 'align-justify', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('34', '33', '0,1,31,32,33,', '查看', null, null, null, '30', '0', '0', 'cms:category:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('35', '33', '0,1,31,32,33,', '修改', null, null, null, '30', '0', '0', 'cms:category:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('36', '32', '0,1,31,32', '站点设置', '/cms/site/', null, 'certificate', '40', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('37', '36', '0,1,31,32,36,', '查看', null, null, null, '30', '0', '0', 'cms:site:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('38', '36', '0,1,31,32,36,', '修改', null, null, null, '30', '0', '0', 'cms:site:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('39', '32', '0,1,31,32', '切换站点', '/cms/site/select', null, 'retweet', '50', '1', '0', 'cms:site:select', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('4', '3', '0,1,2,3,', '菜单管理', '/sys/menu/', null, 'list-alt', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('40', '31', '0,1,31,', '内容管理', null, null, null, '500', '1', '0', 'cms:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('41', '40', '0,1,31,40,', '内容发布', '/cms/', null, 'briefcase', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('42', '41', '0,1,31,40,41,', '文章模型', '/cms/article/', null, 'file', '40', '0', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('43', '42', '0,1,31,40,41,42,', '查看', null, null, null, '30', '0', '0', 'cms:article:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('44', '42', '0,1,31,40,41,42,', '修改', null, null, null, '30', '0', '0', 'cms:article:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('45', '42', '0,1,31,40,41,42,', '审核', null, null, null, '30', '0', '0', 'cms:article:audit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('46', '41', '0,1,31,40,41,', '链接模型', '/cms/link/', null, 'random', '60', '0', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('47', '46', '0,1,31,40,41,46,', '查看', null, null, null, '30', '0', '0', 'cms:link:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('48', '46', '0,1,31,40,41,46,', '修改', null, null, null, '30', '0', '0', 'cms:link:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('49', '46', '0,1,31,40,41,46,', '审核', null, null, null, '30', '0', '0', 'cms:link:audit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('5', '4', '0,1,2,3,4,', '查看', null, null, null, '30', '0', '0', 'sys:menu:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('50', '40', '0,1,31,40,', '评论管理', '/cms/comment/?status=2', null, 'comment', '40', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('51', '50', '0,1,31,40,50,', '查看', null, null, null, '30', '0', '0', 'cms:comment:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('52', '50', '0,1,31,40,50,', '审核', null, null, null, '30', '0', '0', 'cms:comment:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('53', '40', '0,1,31,40,', '公共留言', '/cms/guestbook/?status=2', null, 'glass', '80', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('54', '53', '0,1,31,40,53,', '查看', null, null, null, '30', '0', '0', 'cms:guestbook:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('55', '53', '0,1,31,40,53,', '审核', null, null, null, '30', '0', '0', 'cms:guestbook:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('56', '40', '0,1,31,40,', '文件管理', '/../static/ckfinder/ckfinder.html', null, 'folder-open', '90', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('57', '56', '0,1,31,40,56,', '查看', null, null, null, '30', '0', '0', 'cms:ckfinder:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('58', '56', '0,1,31,40,56,', '上传', null, null, null, '30', '0', '0', 'cms:ckfinder:upload', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('59', '56', '0,1,31,40,56,', '修改', null, null, null, '30', '0', '0', 'cms:ckfinder:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('6', '4', '0,1,2,3,4,', '修改', null, null, null, '30', '0', '0', 'sys:menu:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('60', '31', '0,1,31,', '统计分析', null, null, null, '600', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('61', '60', '0,1,31,60,', '信息量统计', '/cms/stats/article', null, 'tasks', '30', '1', '0', 'cms:stats:article', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('62', '1', '0,1,', '在线办公', null, null, null, '200', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('63', '62', '0,1,62,', '个人办公', null, null, null, '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('64', '63', '0,1,62,63,', '请假办理', '/oa/leave', null, 'leaf', '30', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('65', '64', '0,1,62,63,64,', '查看', null, null, null, '30', '0', '0', 'oa:leave:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('66', '64', '0,1,62,63,64,', '修改', null, null, null, '40', '0', '0', 'oa:leave:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('67', '2', '0,1,2,', '日志查询', null, null, null, '985', '1', '0', null, '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0'), ('68', '67', '0,1,2,67,', '日志查询', '/sys/log', null, 'pencil', '30', '1', '0', 'sys:log:view', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0'), ('69', '2', '0,1,2,', '流程管理', null, null, null, '983', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('7', '3', '0,1,2,3,', '角色管理', '/sys/role/', null, 'lock', '50', '1', '0', null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('70', '69', '0,1,2,69,', '流程管理', '/sys/workflow/processList', null, 'road', '300', '1', '0', 'sys:workflow:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('71', '64', '0,1,62,63,64,', '部门领导审批', null, null, null, '50', '0', '1', 'oa:leave:deptLeaderAudit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('72', '64', '0,1,62,63,64,', '人事审批', null, null, null, '60', '0', '1', 'oa:leave:hrAudit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('73', '32', '0,1,31,32', '模板管理', '/cms/template', null, 'pencil', '40', '1', '0', null, '1', '2013-12-12 08:00:00', '1', '2013-12-12 08:00:00', null, '1'), ('74', '73', '0,1,31,32,73,', '查看', null, null, null, '30', '0', '0', 'cms:template:view', '1', '2013-12-12 08:00:00', '1', '2013-12-12 08:00:00', null, '1'), ('75', '73', '0,1,31,32,73,', '修改', null, null, null, '30', '0', '0', 'cms:template:edit', '1', '2013-12-12 08:00:00', '1', '2013-12-12 08:00:00', null, '1'), ('76', '1', '0,1,', '项目管理', null, null, null, '1000', '1', '0', null, '1', '2013-12-12 08:00:00', '1', '2013-12-12 08:00:00', null, '1'), ('77', '76', '0,1,76,', '项目数据', null, null, null, '30', '1', '0', null, '1', '2013-12-12 08:00:00', '1', '2013-12-12 08:00:00', null, '1'), ('78', '77', '0,1,76,77,', '项目管理', '/prj/project/', null, 'globe', '30', '1', '0', null, '1', '2013-12-12 08:00:00', '1', '2013-12-12 08:00:00', null, '1'), ('79', '78', '0,1,76,77,78,', '查看', null, null, null, '30', '0', '0', 'prj:project:view', '1', '2013-12-12 08:00:00', '1', '2013-12-12 08:00:00', null, '1'), ('8', '7', '0,1,2,3,7,', '查看', null, null, null, '30', '0', '0', 'sys:role:view', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('80', '78', '0,1,76,77,78,', '修改', null, null, null, '40', '0', '0', 'prj:project:edit', '1', '2013-12-12 08:00:00', '1', '2013-12-12 08:00:00', null, '1'), ('8f6085c89bef4df1a603752ef129da79', '1420b2b0e1ba4e4ebc8cd2f7daeaf300', '0,1,f16c9e4782df4920adb58bc620e6809a,1420b2b0e1ba4e4ebc8cd2f7daeaf300,', '普通成绩统计', '/stat/studentscore', '', '', '30', '1', '0', '', '1', '2014-09-05 10:49:26', '1', '2014-09-18 16:25:11', null, '0'), ('9', '7', '0,1,2,3,7,', '修改', null, null, null, '30', '0', '0', 'sys:role:edit', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('e166343cad0e4f3591ac325c6807d0f1', '8f6085c89bef4df1a603752ef129da79', '0,1,f16c9e4782df4920adb58bc620e6809a,1420b2b0e1ba4e4ebc8cd2f7daeaf300,8f6085c89bef4df1a603752ef129da79,', '查看', '', '', '', '30', '0', '0', 'stat:studentscore:view', '1', '2014-09-05 10:50:14', '1', '2014-09-18 16:25:28', null, '0'), ('f16c9e4782df4920adb58bc620e6809a', '1', '0,1,', '学生成绩统计', '', '', '', '200', '1', '0', '', '1', '2014-09-05 10:48:04', '1', '2014-09-18 16:24:25', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_office
-- ----------------------------
DROP TABLE IF EXISTS `sys_office`;
CREATE TABLE `sys_office` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`parent_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父级编号' ,
`parent_ids`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '所有父级编号' ,
`area_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '归属区域' ,
`code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域编码' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构名称' ,
`type`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构类型' ,
`grade`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构等级' ,
`address`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系地址' ,
`zip_code`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮政编码' ,
`master`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人' ,
`phone`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话' ,
`fax`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '传真' ,
`email`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `sys_office_parent_id` (`parent_id`) USING BTREE ,
INDEX `sys_office_del_flag` (`del_flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='机构表'

;

-- ----------------------------
-- Records of sys_office
-- ----------------------------
BEGIN;
INSERT INTO `sys_office` VALUES ('1', '0', '0,', '2', '100000', '北京市总公司', '1', '1', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('10', '7', '0,1,7,', '8', '200003', '市场部', '2', '2', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('11', '7', '0,1,7,', '8', '200004', '技术部', '2', '2', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('12', '7', '0,1,7,', '9', '201000', '济南市分公司', '1', '3', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('13', '12', '0,1,7,12,', '9', '201001', '公司领导', '2', '3', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('14', '12', '0,1,7,12,', '9', '201002', '综合部', '2', '3', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('15', '12', '0,1,7,12,', '9', '201003', '市场部', '2', '3', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('16', '12', '0,1,7,12,', '9', '201004', '技术部', '2', '3', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('17', '12', '0,1,7,12,', '11', '201010', '济南市历城区分公司', '1', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('18', '17', '0,1,7,12,17,', '11', '201011', '公司领导', '2', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('19', '17', '0,1,7,12,17,', '11', '201012', '综合部', '2', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('2', '1', '0,1,', '2', '100001', '公司领导', '2', '1', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('20', '17', '0,1,7,12,17,', '11', '201013', '市场部', '2', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('21', '17', '0,1,7,12,17,', '11', '201014', '技术部', '2', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('22', '12', '0,1,7,12,', '12', '201020', '济南市历下区分公司', '1', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('23', '22', '0,1,7,12,22,', '12', '201021', '公司领导', '2', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('24', '22', '0,1,7,12,22,', '12', '201022', '综合部', '2', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('25', '22', '0,1,7,12,22,', '12', '201023', '市场部', '2', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('26', '22', '0,1,7,12,22,', '12', '201024', '技术部', '2', '4', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('3', '1', '0,1,', '2', '100002', '人力部', '2', '1', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('4', '1', '0,1,', '2', '100003', '市场部', '2', '1', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('5', '1', '0,1,', '2', '100004', '技术部', '2', '1', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('6', '1', '0,1,', '2', '100005', '研发部', '2', '1', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('7', '1', '0,1,', '8', '200000', '山东省分公司', '1', '2', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('8', '7', '0,1,7,', '8', '200001', '公司领导', '2', '2', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0'), ('9', '7', '0,1,7,', '8', '200002', '综合部', '2', '2', null, null, null, null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`office_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '归属机构' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称' ,
`data_scope`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据范围' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `sys_role_del_flag` (`del_flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='角色表'

;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', '1', '系统管理员', '1', '1', '2013-05-27 08:00:00', '1', '2014-09-05 10:50:31', null, '0'), ('2', '1', '公司管理员', '2', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('3', '1', '本公司管理员', '3', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('4', '1', '部门管理员', '4', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1'), ('5', '1', '本部门管理员', '5', '1', '2013-05-27 08:00:00', '1', '2014-09-18 16:27:01', null, '1'), ('6', '1', '统计用户', '8', '1', '2013-05-27 08:00:00', '1', '2014-09-18 16:28:12', null, '0'), ('7', '7', '山东省管理员', '9', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
`role_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编号' ,
`menu_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单编号' ,
PRIMARY KEY (`role_id`, `menu_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='角色-菜单'

;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES ('1', '1'), ('1', '10'), ('1', '11'), ('1', '12'), ('1', '13'), ('1', '14'), ('1', '1420b2b0e1ba4e4ebc8cd2f7daeaf300'), ('1', '15'), ('1', '16'), ('1', '17'), ('1', '18'), ('1', '19'), ('1', '2'), ('1', '20'), ('1', '21'), ('1', '22'), ('1', '27'), ('1', '28'), ('1', '29'), ('1', '3'), ('1', '30'), ('1', '4'), ('1', '5'), ('1', '6'), ('1', '67'), ('1', '68'), ('1', '7'), ('1', '8'), ('1', '8f6085c89bef4df1a603752ef129da79'), ('1', '9'), ('1', 'e166343cad0e4f3591ac325c6807d0f1'), ('1', 'f16c9e4782df4920adb58bc620e6809a'), ('2', '1'), ('2', '10'), ('2', '11'), ('2', '12'), ('2', '13'), ('2', '14'), ('2', '15'), ('2', '16'), ('2', '17'), ('2', '18'), ('2', '19'), ('2', '2'), ('2', '20'), ('2', '21'), ('2', '22'), ('2', '23'), ('2', '24'), ('2', '25'), ('2', '26'), ('2', '27'), ('2', '28'), ('2', '29'), ('2', '3'), ('2', '30'), ('2', '31'), ('2', '32'), ('2', '33'), ('2', '34'), ('2', '35'), ('2', '36'), ('2', '37'), ('2', '38'), ('2', '39'), ('2', '4'), ('2', '40'), ('2', '41'), ('2', '42'), ('2', '43'), ('2', '44'), ('2', '45'), ('2', '46'), ('2', '47'), ('2', '48'), ('2', '49'), ('2', '5'), ('2', '50'), ('2', '51'), ('2', '52'), ('2', '53'), ('2', '54'), ('2', '55'), ('2', '56'), ('2', '57'), ('2', '58'), ('2', '59'), ('2', '6'), ('2', '60'), ('2', '61'), ('2', '62'), ('2', '63'), ('2', '64'), ('2', '65'), ('2', '66'), ('2', '67'), ('2', '68'), ('2', '69'), ('2', '7'), ('2', '70');
INSERT INTO `sys_role_menu` VALUES ('2', '8'), ('2', '9'), ('3', '1'), ('3', '10'), ('3', '11'), ('3', '12'), ('3', '13'), ('3', '14'), ('3', '15'), ('3', '16'), ('3', '17'), ('3', '18'), ('3', '19'), ('3', '2'), ('3', '20'), ('3', '21'), ('3', '22'), ('3', '23'), ('3', '24'), ('3', '25'), ('3', '26'), ('3', '27'), ('3', '28'), ('3', '29'), ('3', '3'), ('3', '30'), ('3', '31'), ('3', '32'), ('3', '33'), ('3', '34'), ('3', '35'), ('3', '36'), ('3', '37'), ('3', '38'), ('3', '39'), ('3', '4'), ('3', '40'), ('3', '41'), ('3', '42'), ('3', '43'), ('3', '44'), ('3', '45'), ('3', '46'), ('3', '47'), ('3', '48'), ('3', '49'), ('3', '5'), ('3', '50'), ('3', '51'), ('3', '52'), ('3', '53'), ('3', '54'), ('3', '55'), ('3', '56'), ('3', '57'), ('3', '58'), ('3', '59'), ('3', '6'), ('3', '60'), ('3', '61'), ('3', '62'), ('3', '63'), ('3', '64'), ('3', '65'), ('3', '66'), ('3', '67'), ('3', '68'), ('3', '69'), ('3', '7'), ('3', '70'), ('3', '8'), ('3', '9'), ('4', '1'), ('4', '10'), ('4', '11'), ('4', '12'), ('4', '13'), ('4', '14'), ('4', '15'), ('4', '16'), ('4', '17'), ('4', '18'), ('4', '19'), ('4', '2'), ('4', '20'), ('4', '21'), ('4', '22'), ('4', '23'), ('4', '24'), ('4', '25'), ('4', '26'), ('4', '27'), ('4', '28'), ('4', '29'), ('4', '3'), ('4', '30'), ('4', '31'), ('4', '32'), ('4', '33'), ('4', '34');
INSERT INTO `sys_role_menu` VALUES ('4', '35'), ('4', '36'), ('4', '37'), ('4', '38'), ('4', '39'), ('4', '4'), ('4', '40'), ('4', '41'), ('4', '42'), ('4', '43'), ('4', '44'), ('4', '45'), ('4', '46'), ('4', '47'), ('4', '48'), ('4', '49'), ('4', '5'), ('4', '50'), ('4', '51'), ('4', '52'), ('4', '53'), ('4', '54'), ('4', '55'), ('4', '56'), ('4', '57'), ('4', '58'), ('4', '59'), ('4', '6'), ('4', '60'), ('4', '61'), ('4', '62'), ('4', '63'), ('4', '64'), ('4', '65'), ('4', '66'), ('4', '67'), ('4', '68'), ('4', '69'), ('4', '7'), ('4', '70'), ('4', '8'), ('4', '9'), ('5', '1'), ('5', '1420b2b0e1ba4e4ebc8cd2f7daeaf300'), ('5', '27'), ('5', '28'), ('5', '29'), ('5', '30'), ('5', '8f6085c89bef4df1a603752ef129da79'), ('5', 'e166343cad0e4f3591ac325c6807d0f1'), ('5', 'f16c9e4782df4920adb58bc620e6809a'), ('6', '1'), ('6', '1420b2b0e1ba4e4ebc8cd2f7daeaf300'), ('6', '27'), ('6', '28'), ('6', '29'), ('6', '30'), ('6', '8f6085c89bef4df1a603752ef129da79'), ('6', 'e166343cad0e4f3591ac325c6807d0f1'), ('6', 'f16c9e4782df4920adb58bc620e6809a'), ('7', '1'), ('7', '10'), ('7', '11'), ('7', '12'), ('7', '13'), ('7', '14'), ('7', '15'), ('7', '16'), ('7', '17'), ('7', '18'), ('7', '19'), ('7', '2'), ('7', '20'), ('7', '21'), ('7', '22'), ('7', '23'), ('7', '24'), ('7', '25'), ('7', '26'), ('7', '27'), ('7', '28'), ('7', '29'), ('7', '3'), ('7', '30'), ('7', '31'), ('7', '32'), ('7', '33'), ('7', '34'), ('7', '35'), ('7', '36'), ('7', '37'), ('7', '38'), ('7', '39'), ('7', '4'), ('7', '40'), ('7', '41'), ('7', '42'), ('7', '43'), ('7', '44'), ('7', '45');
INSERT INTO `sys_role_menu` VALUES ('7', '46'), ('7', '47'), ('7', '48'), ('7', '49'), ('7', '5'), ('7', '50'), ('7', '51'), ('7', '52'), ('7', '53'), ('7', '54'), ('7', '55'), ('7', '56'), ('7', '57'), ('7', '58'), ('7', '59'), ('7', '6'), ('7', '60'), ('7', '61'), ('7', '62'), ('7', '63'), ('7', '64'), ('7', '65'), ('7', '66'), ('7', '67'), ('7', '68'), ('7', '69'), ('7', '7'), ('7', '70'), ('7', '8'), ('7', '9');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_office
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_office`;
CREATE TABLE `sys_role_office` (
`role_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编号' ,
`office_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构编号' ,
PRIMARY KEY (`role_id`, `office_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='角色-机构'

;

-- ----------------------------
-- Records of sys_role_office
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_office` VALUES ('7', '10'), ('7', '11'), ('7', '12'), ('7', '13'), ('7', '14'), ('7', '15'), ('7', '16'), ('7', '17'), ('7', '18'), ('7', '19'), ('7', '20'), ('7', '21'), ('7', '22'), ('7', '23'), ('7', '24'), ('7', '25'), ('7', '26'), ('7', '7'), ('7', '8'), ('7', '9');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号' ,
`company_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '归属公司' ,
`office_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '归属部门' ,
`login_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录名' ,
`password`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码' ,
`no`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工号' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名' ,
`email`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱' ,
`phone`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话' ,
`mobile`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机' ,
`user_type`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户类型' ,
`login_ip`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后登陆IP' ,
`login_date`  datetime NULL DEFAULT NULL COMMENT '最后登陆时间' ,
`create_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_date`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_date`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`remarks`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
`del_flag`  char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标记' ,
PRIMARY KEY (`id`),
INDEX `sys_user_office_id` (`office_id`) USING BTREE ,
INDEX `sys_user_login_name` (`login_name`) USING BTREE ,
INDEX `sys_user_company_id` (`company_id`) USING BTREE ,
INDEX `sys_user_update_date` (`update_date`) USING BTREE ,
INDEX `sys_user_del_flag` (`del_flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='用户表'

;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1', '1', '1', 'thinkgem', 'bab60ed9585d440f4708bad935d31e70bb79fc9e3af99e8ca9afd8ff', '0001', 'Thinkgem', 'thinkgem@163.com', '8675', '8675', null, '0:0:0:0:0:0:0:1', '2014-09-18 16:29:39', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '最高管理员', '0'), ('10', '7', '11', 'sd_jsb', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0010', '山东省分公司技术部', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '山东省分公司技术部', '1'), ('11', '12', '13', 'sdjn_admin', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0011', '济分公司领导', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '济南分公司领导', '1'), ('12', '12', '18', 'sdjnlc_admin', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0012', '济分历城领导', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '济南市历城区分公司领导', '1'), ('13', '22', '23', 'sdjnlx_admin', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0013', '济分历下领导', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '济南市历下区分公司领导', '1'), ('14', '22', '24', 'sdjnlx_zhb', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0014', '济分历下综合部', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '济南市历下区分公司综合部', '1'), ('1faa22c1be314b139827ee6e8019f476', '1', '1', 'stat', 'f48bbadd72521572cda1ba2d317df43cc351e1e5827e3bbf40c9eb93', '001', 'stat', 'stat@163.com', '', '', '3', '0:0:0:0:0:0:0:1', '2014-09-18 17:12:07', '1', '2014-09-18 16:29:39', '1', '2014-09-18 16:29:39', '', '0'), ('2', '1', '1', 'admin', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0002', '管理员', 'thinkgem@163.com', '8675', '8675', null, '0:0:0:0:0:0:0:1', '2014-09-05 13:25:51', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '管理员', '0'), ('3', '1', '3', 'bj_zhb', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0003', '综合部', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '综合部', '1'), ('4', '1', '4', 'bj_scb', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0004', '市场部', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '市场部', '1'), ('5', '1', '5', 'bj_jsb', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0005', '技术部', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '技术部', '1'), ('6', '1', '6', 'bj_yfb', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0006', '研发部', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '研发部', '1'), ('7', '7', '8', 'sd_admin', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0007', '山分领导', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '山东省分公司领导', '1'), ('8', '7', '9', 'sd_zhb', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0008', '山分综合部', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '山东省分公司综合部', '1'), ('9', '7', '10', 'sd_scb', '02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032', '0009', '山分市场部', 'thinkgem@163.com', '8675', '8675', null, null, null, '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', '山东省分公司市场部', '1');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`user_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户编号' ,
`role_id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编号' ,
PRIMARY KEY (`user_id`, `role_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='用户-角色'

;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1', '1'), ('10', '2'), ('11', '3'), ('12', '4'), ('13', '5'), ('14', '6'), ('1faa22c1be314b139827ee6e8019f476', '6'), ('2', '1'), ('3', '2'), ('4', '3'), ('5', '4'), ('6', '5'), ('7', '2'), ('7', '7'), ('8', '2'), ('9', '1');
COMMIT;

-- ----------------------------
-- Auto increment value for demo1_student_score
-- ----------------------------
ALTER TABLE `demo1_student_score` AUTO_INCREMENT=13;
